How To Connect SQL Server with Internet
HTML-код
- Опубликовано: 19 окт 2012
- 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
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.
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.
Great tutorial! Right on the spot and valid many years ahead!
Awesome job. You rescured me from 6hrs troubleshooting
That's exactly what i wanted and searching for over the weeks. Thank you very much
I never seen any tutorial as good as this!
Thanks you so much!!!!!
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
Thanks!!! This is the best tutorial.
Many many thanks for this tremendous tutorial...it helped me figure out my problem to connect....you are Boss
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.
Great video. Still relevant. Helped me out a lot today. Perfect. Thanks, Kranthi!
thanks for sharing helpful video, pls make more videos
Thanks for sharing this very useful information.
The best Tutorial, Thanks Kranthi Kumar Sb.
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.
Great job dude! Well done! well detailed explanation! Thank you
Connected remotely via VPN even! Big thanks!
Very good explanation.. thank you very much...
Hey, this was great. Really helpful! I subscribed!
Thanks for your support, rely appreciated.
I really appreciate your this particular video. Very helpful thanks.
Thank you so much! Hope all good things for you!
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
GOOD, informative
Very nice tutorial.... tnx a lot
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!!!!
Well done Kranthi,
Hi it was a very good example i finally got how to connect sqlserver online Thank You !
Great video. I have learnt so much from it.thank you.
Excellent video. Thank you!
Saved my life, thanks!
Helped me alot .Thanks!
very helpfull thank you so much sir
11:55 you put all the ports open, you can also turn off your firewall.
I think you have then the same result.
Simply Excellent, thank you ji
Very good tutorial...
Thank you. It was really helpful for me.
Thank you!! It helps me in a hard time in here!!
Thank you so much for this video.. :)
thanks for the video. much appreciated.
Nice Tutorial thanks was usefull
Thank you so much !! It helped me a Lot
Thank you so much for your presentation
Thanks a lot, Kranthi!!!
Helpfull in 2021 ! Thanks
thanks man, great tut, gj.
Thanks for your video, it really usefull for me.
I love you
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
hello you are great.. thanks for tutorial.. keep it up.. I am a newbie and i learned something new to me.. :)
many thanks to you my friend!
Simply genius!!
Many thanks Sir!
Very helpful. Thank you.
Hi! Thanks! Very good!
Thanks a lot for your help
thanks it was very helpfull
Depois de apanhar bastante! Funcionou!
thanks, good work
thanks for this video
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/
excellent!!! it help me thanks
Thanks.. Good Job..
Thanks a ton
thank very much !
Excellent
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
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.
thank you :)
Good job! ;-)
thanks sir your video very was very helpful
Thanks so much
awesumm (y)
Nice
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.
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.
Thanks
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.
excellent
Yes. you should have to open 1433 to connect your sql server through NET.
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?
good show.
well define, well explained Thumbs up for Kranthi. i have one question in mind. Are you familiar in MLM programming?
thanks so much
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
Interesting... :)
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!!!
should you connect to the server pc using ethernet? cause i tried with portable wi-fi i am not getting connected. Please advise
Is it possible to do this with 2 computers running SQL Express??? I tried your way but no luck. Thanks
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) ?
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
I don't have any other services, only SQL server. I have done the same but I can not connect through the internet, it works fine with the local network. FYI, I am using NetGear Router.
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
how do i get the folder SQL Server 2008 R2 ? I have SSMS and SQL Server 2016 installed but dont have that folder.
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?
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 ?
Is it working on MySQL Workbench ?
By the way, thanks for that tutorial
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