Sep
19
2013

Allowing remote connections to SQL Express (the right way) (video)

Sometimes we need to allow remote connections to a SQL Server Express or Developer edition instance, usually on our local machine. In this video demo, I show you how to allow remote access without resorting to disabling the Windows Firewall entirely, which is an unfortunately-common solution pervading the internet.

 

 

Since there are many possible configurations (which is why I say "default" a lot in the video -- sorry), and part of what I covered applies to all editions of SQL Server, a much more complete reference can be found here on MSDN.

Comments are closed