How To Connect SQL Server with Internet

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

[@olexandrpanov5987]

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!!!

[@sivaragu3391]

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

[@jlma64]

Thanks for you video. It has helped me three years later than you did it. You explain very well.

[@aartpieterschouten6588]

11:55 you put all the ports open, you can also turn off your firewall. I think you have then the same result.

[@MdRuhulAminSarker]

Many many thanks for this tremendous tutorial...it helped me figure out my problem to connect....you are Boss

[@alibahar1417]

The best Tutorial, Thanks Kranthi Kumar Sb.

[@tabrezahmed7371]

Hi it was a very good example i finally got how to connect sqlserver online Thank You !

[@henrybroadcast]

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.

[@ehinolakingsley4000]

Awesome job. You rescured me from 6hrs troubleshooting

[@williamlapitan4821]

Very nice tutorial.... tnx a lot

[@parameshpenikelapati3217]

thanks for sharing helpful video, pls make more videos

[@AhamedRikaz]

Simply Excellent, thank you ji

[@DamianChambers]

Great video. I have learnt so much from it.thank you.

[@haydenmoore8251]

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.

[@JamesDamitSoftwareTester]

Thanks for sharing this very useful information.

[@aida1111]

I never seen any tutorial as good as this! Thanks you so much!!!!!

[@asdgqgqwe]

Great tutorial! Right on the spot and valid many years ahead!

[@freddiesoft]

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.

[@afzalhossainbd]

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.

[@andrewdavis6917]

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.

[@mohammadwaheed6121]

hello sir, your video is very helpful to all of us

[@osamahlhm9074]

i tried to open a connection using c# grid view but it is not connect can u please send me an sqlserver driver

[@sanjuk2325]

Helpfull in 2021 ! Thanks

[@DeeKayGoswami]

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!!!

[@WEnASSAM]

Thanks!!! This is the best tutorial.

[@laisanogueira6897]

Very good explanation.. thank you very much...

[@TheZahid2008]

Very good tutorial...

[@hendrawawan4897]

Thanks.. Good Job..

[@anthonyquijano7697]

hello you are great.. thanks for tutorial.. keep it up.. I am a newbie and i learned something new to me.. :)

[@harveybains146]

Great Video. Now I can connect through the internet.

[@birenpatel6211]

i perform all the steps but i can't connect can you please help me thank you in advance

[@gregoryregan3000]

Great video. Still relevant. Helped me out a lot today. Perfect. Thanks, Kranthi!

[@WholesalePetcare]

I really appreciate your this particular video. Very helpful thanks.

[@rwdicky1]

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.

[@Ozora2023]

Thank you so much! Hope all good things for you!

[@impactours9687]

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.

[@gustavodefaustinomiranda4380]

Thank you!! It helps me in a hard time in here!!

[@GiorgiGogenia]

That's exactly what i wanted and searching for over the weeks. Thank you very much

[@stevetan8029]

well define, well explained Thumbs up for Kranthi. i have one question in mind. Are you familiar in MLM programming?

[@rikisax63]

Many thanks Sir!

[@dasegu94]

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?

[@khpalbazar7976]

very helpfull thank you so much sir

[@abdulquadir9342]

should you connect to the server pc using ethernet? cause i tried with portable wi-fi i am not getting connected. Please advise

[@shekhar_bhaskar]

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

[@darshanpatil8825]

thanks sir your video very was very helpful

[@christysam8092]

Thanks for your video, it really usefull for me.

[@sathishshetty9012]

GOOD, informative

[@douglasrich2203]

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!!!!

[@SQLSERVERONLINE]

Yes. You can connect C# application but your SQL server address should be your Public IP address.

[@SQLSERVERONLINE]

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 [e-mail]. 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 [e-mail]

[@MrSanyabandaru]

Super...! U rock.

[@BlackMan437]

+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

[@abdulazizpanhalkar4363]

Static public may help you. OR just check www.noip.com/

[@marjaniminty8543]

Connected remotely via VPN even! Big thanks!

[@nagarajnadar]

Thank you so much for your presentation

[@amoscookie1336]

But is it necessary to expose RDP? Let said I only interested to pull some data from the tables from public Internet

[@JayeshMItaliya]

Nice Tutorial thanks was usefull

[@YousifAshwal]

Well done Kranthi,

[@daddybl2002]

Thank you. It was really helpful for me.

[@stevetan8029]

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

[@jahnavij7047]

Please upload your notes to the site.So , that we can work the same examples you used in the video's for practise.

[@SQLSERVERONLINE]

Yes. you should have to open 1433 to connect your sql server through NET.

[@shakirahmed6569]

Great job dude! Well done! well detailed explanation! Thank you

[@ayamniyazi9076]

hi ; thank u for this useful video,itry to connect my computer to our local server but it is fail,

[@nikolaobretenov8673]

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 !!!

[@yourharkat123]

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) ?

[@darshana29]

Thanks for your support, rely appreciated.

[@mohsinjawed5328]

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.

[@Bhavis-Kitchen]

Thanks a lot, Kranthi!!!

[@jrm2376]

excellent

[@Tamal78]

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 .

[@michaelhbalz]

Excellent video. Thank you!

[@SQLSERVERONLINE]

Your router should have PORT FORWARDING option on left side.

[@techwee]

Very helpful. Thank you.

[@danielluiz1893]

Hi! Thanks! Very good!

[@rohitrocking6536]

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

[@ricsteiner4742]

Is it possible to do this with 2 computers running SQL Express??? I tried your way but no luck. Thanks

[@omnarayan7066]

Nice

[@sarif75]

Simply genius!!

[@sheikhmuzammil89]

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?

[@jeromedcruz1021]

thanks it was very helpfull

[@SnakeOilDev]

Helped me alot .Thanks!

[@matejtrajkovski]

Saved my life, thanks!

[@dumitru322]

Hi Kranthi, can you tell me please, how should I indicate Server for ODBC connection? I try to connect MS Access to the SQL Server. For (local) server it works perfect, but I don't know how to set for remote connection.

[@abdevillier679]

Same issue I am also facing while connecting Ms access with different system where SQL has installed

[@ashaseeb]

excellent!!! it help me thanks

[@rutujakulkarni1355]

Thank you so much !! It helped me a Lot

[@cismancadawe7616]

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

[@aggelostzitzifas5146]

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

[@nuzumwahulul8348]

Thanks a lot for your help

[@bestinpsebastian4381]

Thank you so much for this video.. :)

[@NASSER199200]

thanks!!! I connect sql server but want connect into DNS not ip adresse how to do that ???

[@MJVelascoSalvador]

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?

[@DeeKayGoswami]

Yes I Know That...but HOW???? and Which Port Number should I Have To Forward???

[@maheeshamadhubashini4449]

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?

[@carolinecraig6253]

Hey, this was great. Really helpful! I subscribed!

[@axpence]

thanks for the video. much appreciated.

[@tomyang7788]

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 ?

[@ShirazKI]

how to manage this in dynamic ip address bcz our public is is not static

[@akifmalik9388]

I there a way to connect from different Networks?

[@saudiazful]

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.

[@ashishkmehta]

Excellent

[@tomyang7788]

how do i get the folder SQL Server 2008 R2 ? I have SSMS and SQL Server 2016 installed but dont have that folder.

[@ehinolakingsley4000]

Please I have a question. If I develop and application an I hard my IP address into the sql connection string. Question 1: if my IP address change, my connection will fail. Question 2 how can I resolve this dynamic IP address from ISP

[@kumaraman0007]

what happens when an ISP static ip is down.....then how to use the sql server from client pc?

[@kennethbryanmanalo1753]

Is it working on MySQL Workbench ? By the way, thanks for that tutorial