How To Connect SQL Server with Internet
HTML-код
- Опубликовано: 8 фев 2025
- This Video is to show How to connect SQL Server through Internet:
Steps:
Find out IP Address for SQL Server machine
Make to Static IP Address
Find Port Address for SQL Server
For Default it's 1433
For Name Instances it varies so make it Static Port Number
Install and Enable SQL Server Browser
Open a Firewall Settings for SQL Server and SQL Server Browser
Enable the Port Forwarding on you Router with SQL server ports
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Thank you very much! I couldnt do it for 6 months! And 20 minutes video helped me! It is the best tutorial I've ever seen. Very simple language, very good explaining. Mr. Kranthi many thanks!!!
Thanks for you video. It has helped me three years later than you did it. You explain very well.
Thank you thank you very much Mr.kranthi. no words to say many thanks it's very helpful.i tried this for 2 days before seeing this video now you solved my problem Thank you very much
Awesome job. You rescured me from 6hrs troubleshooting
Hello Everyone,
I added another new course called “ SQL Server 2012 : Performance Tuning in Action with 100 million + rows”.
It is going to be started very soon. For complete course description and other details, please contact me at kranthi.sqlserver@gmail.com.
Technical Highlights:
• Analyze performance bottlenecks
• Analyze the SQL query Performance
• Design an effective index strategy
• Database Engine Tuning Advisor
• Analyze Dynamic Management Views (DMVs)
• Analyze Statistics and Fragmentation levels
• Diagnose and avoid blocking and deadlocks
• Analyze execution plans
• Develop efficient queries and stored procedures
• Analyze and Design the effective query to INSERT a large volume of data ( 100 Million + rows)
• Analyze and Design the query to UPDATE the large volume of data ( 100 Million + rows)
• Cursor Cost Analysis vs SET based Analysis
• Limitations on MERGE statement
• How to manage and deal with Enterprise Production server issues
Thanks,
Kranthi
Microsoft Certified Professional
Kranthi.sqlserver@gmail.com
Super...! U rock.
+Kranthi Kumar due to the fact that the public IP changes every time i connect, it becomes difficult for me to connect to a computer that is on a remote location without knowing its current IP. i want a type of connectivity that can happen anytime without having to contact the remote user to give me their public IP
Static public may help you. OR just check www.noip.com/
Hi it was a very good example i finally got how to connect sqlserver online Thank You !
Many many thanks for this tremendous tutorial...it helped me figure out my problem to connect....you are Boss
That's exactly what i wanted and searching for over the weeks. Thank you very much
The best Tutorial, Thanks Kranthi Kumar Sb.
Thank you a lot! Kranthi,
You opened what it was a black box for me. This will save me some money when using my own box while creating prototypes apps. God bless you.
I never seen any tutorial as good as this!
Thanks you so much!!!!!
Very nice tutorial.... tnx a lot
Really good walk through. Thank you so much, had it all working within 15 minutes. SQL Server Express on a Windows 7 machine. again, much appreciated.
Thank you!! It helps me in a hard time in here!!
Great tutorial! Right on the spot and valid many years ahead!
Very well done. I got a lot of good information and some good explanation of the internal workings for connecting to a SQL Server instance.
thanks for sharing helpful video, pls make more videos
Great video. Still relevant. Helped me out a lot today. Perfect. Thanks, Kranthi!
Great video. I have learnt so much from it.thank you.
hello you are great.. thanks for tutorial.. keep it up.. I am a newbie and i learned something new to me.. :)
Simply Excellent, thank you ji
hello sir, your video is very helpful to all of us
i tried to open a connection using c# grid view but it is not connect can u please send me an sqlserver driver
I really appreciate your this particular video. Very helpful thanks.
Thank you so much! Hope all good things for you!
Thanks for sharing this very useful information.
Thanks a lot, Kranthi!!!
Very good explanation.. thank you very much...
Well done Kranthi,
Great Video. Now I can connect through the internet.
i perform all the steps but i can't connect can you please help me thank you in advance
Very good tutorial...
11:55 you put all the ports open, you can also turn off your firewall.
I think you have then the same result.
Helpfull in 2021 ! Thanks
Thanks for your video, it really usefull for me.
Thanks!!! This is the best tutorial.
Thanks.. Good Job..
excellent!!! it help me thanks
very helpfull thank you so much sir
should you connect to the server pc using ethernet? cause i tried with portable wi-fi i am not getting connected. Please advise
Many thanks Sir!
GOOD, informative
Nice Tutorial thanks was usefull
Thank you so much for your presentation
Connected remotely via VPN even! Big thanks!
Excellent video. Thank you!
Thank you so much !! It helped me a Lot
Great job dude! Well done! well detailed explanation! Thank you
Hi! Thanks! Very good!
thanks sir your video very was very helpful
Very helpful. Thank you.
Hey....Great Tutorial !!!.. I Followed All Steps and got Success in Connecting From Local IP Address only....But I Failed To Connect From Public IP.... I've TP-Link Router so i would be so grateful if you will Give me the steps for port forwarding ........Service Port and Internal Port...etc!!!
Thank you so much for this video.. :)
Saved my life, thanks!
Helped me alot .Thanks!
thanks it was very helpfull
Thanks a lot for your help
Hi, I created a database using SQL on my server, and then created a program that connects to that database and can make changes. if I install that program on multiple computers, i want it to be able to make changes to the database so other computers can see it. Also when I was adding sqlbrowser, the sql server wasn't there. If you could help me out with this, I'll appreciate it, thank you.
But is it necessary to expose RDP? Let said I only interested to pull some data from the tables from public Internet
Thanks for your support, rely appreciated.
Hey, this was great. Really helpful! I subscribed!
You are awesome!!! Great tutorial....one thing that got ensure you use the Default Port 1433 or change it in the Default Port in Client Protocols,
Thanks again!!!!
i like this tutorial....
how about if the ip public is dynamic, means changes from the internet provider ?
can the mssql connect using host name not by ip ( i tried using free ddns service) ?
Is it possible to do this with 2 computers running SQL Express??? I tried your way but no luck. Thanks
Hi! This is great! But I have a question. What should I do if I want to connect to the SQL Server from another computer connected to another network?
Simply genius!!
This is really helpful.. however can you connect to the SSRS through the internet also? I've tried everything but if I come in through the IP address, I can not log in to the SS Reports as rather than logging as domain, it is logging as the IP address.
well define, well explained Thumbs up for Kranthi. i have one question in mind. Are you familiar in MLM programming?
in my sql server configuration manager i don't have that option Protocols for MSSQLServer at 5:20... how to find out which port SQL Server is using ?
thanks for the video. much appreciated.
Hi Kranthi Kumar im a total newbie here on sql. i want to know how you create Protocols for COREQA? can you post another tutes on how to add protocols under SQL Server Network Configuration
Please upload your notes to the site.So , that we can work the same examples you used in the video's for practise.
why should i have to install sql server browser service when i am using default instance with default port 1433 ?? beacuse sql server browser listen at 1434 port no for udp connections?
if i have the sql server stand alone installation installed can i install a New R Server to get the the SQL Server configuration manager
I there a way to connect from different Networks?
sir if we have created a web page and we have server to is there any need to have web host and domain .
hello.. In Server network Configuration ,i don't have it ,how i can to create them .
or what edition of sql express 2012 i download for this propocols sql coreqA and coreDev installed . I work on Winserver2012r OS and sqlexpres 2012
thanks man, great tut, gj.
Hello Kranthi!
Umm, I was able to add the SQL Browser Service, but the SQL Server itself isn't visible in my Allowed Programs. Can you tell me where it's location is?
excellent
Excellent
many thanks to you my friend!
thanks for this video
Hey Kranthi! Its great You are giving so much information - but I have the same problem as Goswami :(. I'm using Tenda W541R router - and here aren't "Port Forwarding", but what i read on the internet - it is Virtual Server on my router. I entered the same ports as You are, but I can't connect. Can You help me please, here or if it is possible to speak via Skype or e-mails - it will be great. I really want to start that server! Thanks !!!
Yes. you should have to open 1433 to connect your sql server through NET.
how do i get the folder SQL Server 2008 R2 ? I have SSMS and SQL Server 2016 installed but dont have that folder.
thanks!!! I connect sql server but want connect into DNS not ip adresse how to do that ???
Hi, this is a very helpful video. Many thanks to you! I was able to connect my other PC to my server by using my public IP address. however when I tried connecting from a different location using my main location's public IP, it doesn't work. Need advice. Thanks.
Thanks Kranthi Kumar ji for this informative video.. I followed every step as narrated by u but unfortunately i m not able to make remote connection for SQL server 2014 express edition. I get error message showing error 26... Can u help me please... Regards.. Shekhar
hi ; thank u for this useful video,itry to connect my computer to our local server but it is fail,
Nice
can some help me i do all steps one by one and i still got on Error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(Microsoft SQL Server
something else, If I use that application in another house, I have to open this port, the port 1433 and the other. or this is only to the Server.
Hi Kranthi, Great Video, would it be possible for you to assist me online ?
Hi, I have followed your steps, I have netgear Router and done with port forwarding, I am able to connect to SQL server with local IP, but not with Public IP, getting error as a network related or instance specific error
Your router should have PORT FORWARDING option on left side.
In my website, the database is ms sql and I used yii framework. For connect the yii with ms sql, I used the apache in xampp. Now I want to host the website. How can I do it?
If you assign static ports to each intance then you don't need the sql server browser. You can connect specifying ip and port. Then port forwarding does the job.
how to manage this in dynamic ip address bcz our public is is not static
Sir I face some problem with router configuration. I use DLINK DIR-600M router. Please guide me how to configure port forwarding in this router.
Here I find out a option Port Triggering. But some how I can't configure it properly .
thanks, good work
Yes I Know That...but HOW???? and Which Port Number should I Have To Forward???