SQL Server allows configuration of remote connections

If you cannot remotely connect to a SQL Server server on your server by 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, and then click SQL Server Management Studio, in Object Explorer, right-click your server and Execute 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:

(This is used by the total administrator, generally in security considerations we want to allocate an account for each database to manage the database)

6. Click "Start" of Windows, select "All Programs", "Microsoft SQL Server", then "configuration Tools", then click "SQL Server Configuration Manager", select the node "MSSQLSERVER protocol" on the left side of the window, and 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.

　　

Windows XP and Windows Server 2003 set up firewall exceptions

Add Port exceptions

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

Windows 7 or Windows Server 2008 firewall exception settings

Add Port exceptions

1. Open Windows Firewall and click Advanced Settings:

2. In the Advanced Settings window, click Inbound Rules, then right-click Inbound rules and execute new rule from the shortcut menu:

3. In the New Rule window, rule type select "Port" and click Next:

4. Rule Application Select TCP, enter the port number 1433, and click Next:

5. Select "Allow Connection" and click Next:

6. Select the rules as needed and click Next:

7. Enter a name and click the "Finish" button:

SQL Server allows configuration of remote connections