How to allow remote connections to SQL Server Express

Can't connect remotely to SQL Server? Watch Microsoft Certified IT Professional Jon Seigel show you how to allow remote connections to SQL Server Express and Developer edition instances without disabling the Windows Firewall.

Blog post for this video:

Visit my channel for more database administration videos:

Subscribe to get notified about my latest videos:

Read additional content on my blog:

Follow on Twitter:

Like on Facebook:

[gass]

Congrats for your initiative, it's very useful for lot of people especially to foreigners because you speak smoothly to helping people non native english speakers.

[VictorChavesVVBC]

Got it working, thank you!

Tip for other viewers: If you are doing this for the default instance, remember it has no name and you only need to provide the IP adress to connect to it in SQL Management Studio. Do not type MSSQLSERVER, SQLEXPRESS, name of the machine or whatever.

[corrpside]

3 year and still helps. Thanks for the tutorial and for you time.

[davidyoo]

thank you so much!!! I've been reading articles about opening the firewall rule. but none of them worked. Yours is the first one to suggest the database instance. And it worked!

[AnthonyGriggs]

You are the Man!! Thanks... I really appreciate the walk through as many articles assume working hardware configuration knowledge. I'm just a developer who is used to developing in already configured environments... I've been setting up some environments myself lately... but a lot of times it's hard as so many who instruct you on these processes assume you are familiar with a lot of it!

[AndrewCoody]

This was a perfect resolve for my connection issue! I have a Win7 ("server" with 2012) and a WinXP ("client" with 2008) and I was able to figure out on my own how to get 1433-1434 in the firewall listings, to also allow remote access, configure the DB for mix mode, and allow 100 compatibility. But, in all these efforts I could not get past the long logon error message. Searching Google yielded to add sqlbrowser as a firewall rule but that did nothing. Only via your video did I find out the only thing I missed was the custom SQL Server rule. Thank you!!!

[zoltanvarnai]

I have tried many instruction from the WEB, but only yours working for me. Many thanks.

[MJ]

I really love to know about DBMS. As a developer, I just knew insert, update, delete, procedur, function, indexer. Its help me a lot to get knowledge overall, I hope you can upload more and more, I subscribed you and really appreciate you. :)

[mikecaldera]

Thank you Million Times. Works. You got all the steps with firewall. I missed one step.

[kantharao]

Thanks a lot for the amazing video, this is what exactly I needed. Adding firewall to allow specific service is what I missed in my configuration, now it works like charm.

[turn]

I was fiddling about for ages until I saw this. Thank you so much Jon

[Rich-idkc]

Really nice video. Clear, concise, and provided a simple process to follow to allow networked connections. Thank you for posting this, I really appreciate the time/effort you put into this.

[Paschendale]

Thank you so much for this video. Forgot I needed the SQL Browser service active to access my named instance.

Thank you very much! I tried a bunch of tutorials on this and none worked but this one did! Thank you very, very much! :D

[ImmacHn]

You have no idea how much this helped, thank you very very much!

[jerryhd]

BRAVO!!!! Well Done... Been battling with this for days then saw your video and it all came clear.... Thank you for everything you

[jamesyangcq]

Best video tutorial ever; very good quality of video, clear instructions with demo, good job.
Hope to see more videos from you. Thanks a lot!

[donharned]

I want to thank you very much for taking the time to others such as myself.

[TheRobertralph]

Really great! Thanks for the info. I liked the thoroughness and calm delivery.

[JEEspinar]

Great job, You helped me a lot with this video, I've searched a lot of videos And I Must tell Your video is the best. Greetings from Ecuador.