Kudos to Scott Elliott a colleague of mine for putting this together...

Here is how I got my SQL Express to remotely respond to SQL Management Studio.

In SQL Server Configuration Manager:
Under SQL Server 2005 Network Configuration:
Protocols for

  • Enable Shared Memory
  • Enable Name Pipes
  • Enable TCP/IP

Under SQL Server 2005 Servers

  • SQL Server (ServerInstance) Properties

Log on as: Local System (have to restart)
SQL Server Browser

  • Log on as: Local System (may have to enable this service first in the Services MMC applet)

And with that, you should be able to remotely connect! Hazzah!

Technorati Tags: , , ,