How to make my local SQL Server Express (which part of Visual Studio) available from outer network?
+4
A:
You need to set it up to allow remote connections (not enabled by default for express editions). See this KB article for details for SQL 2005.
Or this article for SQL 2008 instructions
Martin Smith
2010-08-27 17:21:42
Just as a FYI, the Surface Area Configuration has been discontinued in 2008, in 2008 you need to run Configuration Manager, then enable TCP/IP and remote connections
SQLMenace
2010-08-27 17:23:54
@SQLMenace - Thanks. I've added a SQL 2008 specific link in.
Martin Smith
2010-08-27 17:26:10