Enabling Remote Access to SQL Server Express
December 15, 2009
By default SQL Server Express doesn't listen for connections via TCP/IP. To fix this:
- Open up the SQL Server Configuration Manager
- SQL Server 2005 Network Configuration / Protocols for SQLEXPRESS
- Right click TCP/IP, Enable
- Right click TCP/IP, Properties
- Get the port number to use from IPAll/TCP Dynamic Ports
