Workaround for SQL Server 2005 cannot connect remotely

Previously connected to a local database, connecting to SQL Server 2005 is a side dish ...

Do project is also the teacher set up the server side, hit the IP to access on the line ... Don't even think about it too much.

Today in the company to take the SQL Server 2005 server, the client to access the problem is coming ...

Connection failed, SQL Server 2005 does not support remote ...

Think should not, so think of what the teacher said before, the server side to do configuration ... wow haha!~~ sure ...

Here's how:

first, 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:

third. 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:

fourth. 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.

fifth. 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 ...

sixth. Test Connection

Open the Login screen and enter the server IP and user name and password.
Such as:
Server name: 192.168.0.112, port number (if the port in TCP/IP was 1433, you can omit the port number)
User name: SA
Password: SA

Click Connect, enter the main interface, congratulations, the connection was successful, the previous configuration was successful. Wqy ...