The problem of SQL Server Remote connection failure is solved.

The problem of SQL Server Remote connection failure is solved.

When the charging system of the IDC is released remotely, you must ensure that the database can be remotely connected. However, an error is usually reported during connection:

To solve this problem, you must first check the settings of SqlServer. (These settings are generally system default items, but you 'd better take a look)

(1) Check whether SQL Server allows remote connection. Log in as SqlServer identity authentication. Logon account sa

(2) Open the Configuration Manager and check whether the TCP/IP protocol of Microsoft SQL Server is enabled.

 

Make sure that the preceding settings are correct and then configure the SQL Server firewall. (most of the problems are found here)

 

1. Firewall can be directly disabled, but this is not secure and is not recommended.

2. Find the TCP/IP protocol of Microsoft SQL Server. When the SQL Server firewall is running, click "TCP/IP protocol" and select Properties.

 

We can see that port 1433 supports the TCP/IP protocol on this SQL Server. The next step is to allow port 1433 to support the TCP/IP protocol in the firewall configuration. Open Control Panel and choose Windows Firewall> advanced settings ". Right-click the Inboud Rules option and select NewRule )":

 

Open the "new rule" option and use the "new inbound rule wizard" to configure "Internal binding protocol" for port 1433 to apply to the TCP/IP protocol.

Configuration process:

After completing the preceding steps, the SQL Server supports remote connections. Try it!

The above is all the content in this article. I hope you can learn to solve the problems encountered during remote connection.