Workaround for SQL Server 2005 cannot be remotely connected (reprint)

Here's how:

One, enable remote connections for SQL Server 2005
1. Click Start, select Programs, choose Microsoft SQL Server 2005, configure tools, and then click SQL Server Surface Area configuration.

2. On the SQL Server Surface Area Configuration page, click Surface Area Configuration for services and connections.

3. On the surface area configuration for services and Connections page, expand Database Engine,

Click Remote Connections, select the local area Connection and remote connections check box, select the appropriate protocol for your environment (I use TCP/IP here), and then click Apply.

Note: When you receive the following message, click OK.  changes made to the connection settings will not take effect until the Database engine service is restarted.

Figures:

Second, enable the SQL Server Browser service
1. Click Start, select Programs, choose Microsoft SQL Server 2005, configure tools, and then click SQL Server Surface Area configuration. 2. On the SQL Server Surface Area Configuration page, click Surface Area Configuration for services and connections. 3. On the surface area configuration for services and Connections page, click SQL Server Browser, click the Automatic option in Startup type, and then click Apply. 4. Click Start, and then click OK.

Figures:

Iii. creating an exception for SQL Server 2005 in Windows Firewall
1. In Windows firewall, click the Exceptions tab, and then click Add Program. 2. In the Add Programs window, click Browse. 3. Click C:\Program Files\Microsoft SQL server\mssql.1\mssql\binn\sqlservr.exe Executable, click Open, and then click OK.

Note: The above paths may vary depending on where SQL Server 2005 is installed .

Figures:

Iv. creating an exception for SQL Server Browser in Windows firewall
1. In Windows firewall, click the Exceptions tab, and then click Add Program. 2. In the Add Programs window, click Browse. 3. Click C:\Program Files\Microsoft SQL server\90\shared\sqlbrowser.exe Executable, click Open, and then click OK.

Note: The above paths may vary depending on where SQL Server 2005 is installed .

V. Remote connection Port settings

1. Open SQL Server Configuration Manager on the server.

Method: Click Start, select Programs, choose Microsoft SQL Server 2005, configure tools, and then click SQL Server Configuration Manager.

Then select "SQL Server 2005 Network Configuration", "SQLExpress protocol", and right-click on "TCP/IP" on the right to open the properties.

Figures:

2. Select the "IP Address" tab in the TCP/IP Properties window,

Then, in "IPALL", modify the value of the "TCP port": (General input 1433, but if there is a problem with the connection , can be set to other open ports )

Figures:

3. Of course it is to restart the service ...

Vi. Test Connection

Open the Login screen and enter the server IP and user name and password. For example: Server name: 192.168.0.112, port number (if port is 1433 before TCP/IP, the port number can be omitted) User name: sa password: sa

Workaround for SQL Server 2005 cannot be remotely connected (reprint)