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