SQL Server 2008 allows remote connection configuration

If you are unable to remotely connect to your SQL Server 2008 server through an IP address, you can set it up by referring to the following content. Before you make the following settings, make sure your network is installed and the server is connected to the network properly.

1. Click Start for Windows, select All Programs, choose Microsoft SQL Server 2008, and then click SQL Server Management Studio, in Object Explorer, right-click your server, To perform the properties from the shortcut menu:

2. Select "Security" on the left side of the Server Properties window and select "SQL Server and Windows Authentication Mode" on the right side:

3. Back to Object Explorer, under node "security → logins", right click on the login "sa" and execute "Properties" from the shortcut menu:

4. First, in the Login Properties window, select "General" on the left, and enter the password on the right:

5. Then select "Status" on the left side of the Login Properties window and select "Grant" and "enable" on the right:

6. Click "Start" of Windows, select "All Programs", "Microsoft SQL Server 2008", "Configuration Tools", and then click "SQL Server Configuration Manager" to select the "MSSQLSERVER protocol" on the left side of the window. On the right, double-click TCP/IP:

7: In the TCP/IP Properties window, select the "IP Address" tab, set the IP address and port number, the port number is generally 1433:

8, then select the node "SQL Server service" on the left side of the window and right-click on the right side of SQL Server (MSSQLSERVER) to perform a "restart" from the shortcut menu:

9. If the server is already enabled for Windows Firewall, you must add an exception to allow other computers to connect to the SQL Server service for this server.
The following are examples of Windows XP and Windows Server 2003, if you are using Windows 7/vista or Windows Server 2008, refer to: Setting up a firewall for Windows vsita/7/2008

Add Port exceptions

In Windows firewall, select the Exceptions tab, click Add Port, enter the port number 1433, and then click the OK button:

Add program exceptions

In Windows firewall, select the Exceptions tab, click Add Programs, in the Add Programs window, click Browse, and select C:\Program Files\Microsoft SQL Server\mssql10. Mssqlserver\mssql\binn\sqlservr.exe "executable file, and then click the OK button:

Tip: The above executable path may vary depending on where SQL Server 2008 is installed.

After the above settings, other computers can connect to this server by IP address, connection method please refer to: Connecting SQL Server 2008

It is important to note that when connecting to a remote SQL Server server over an IP address, you should select the option "Allow password to be saved":

SQL Server 2008 allows remote connection configuration