From: http://www.th7.cn/Article/sj/ MS/200808/327516 _2.html
Enable remote connection on an sqlserver instance
◆ 1. Point to "start-> Program-> Microsoft SQL Server 2005-> Configuration tool-> SQL Server peripheral application configurator"
◆ 2. On the "SQL Server 2005 peripheral application configurator" page, click "service and connected peripheral application configurator"
◆ 3. Click expand "Database Engine", select "remote connection", and select "local connection and remote connection" on the right ",
Select the Protocol to use (TCP/IP and named pipe service should be enabled here !) Click "application" and you will see the following message:
"The changes made to the connection settings will not take effect until the Database Engine service is restarted .", Click OK to return
◆ 4. Expand "Database Engine", select "service", click "stop" on the right side, and wait until the MSSQLServer service is stopped,
Click Start to restart the MSSQLServer service.