Troubleshoot problems with SQL Server remote connection failure _mssql

When the computer room toll system is released offsite, it is necessary to ensure that the database can be connected remotely, but the connection usually complains:

To solve this problem, you first need to check several of the SQL Server settings. (These settings are typically system defaults, but it's best to look at them)

(a) Check whether SQL Server allows remote links. Log on as a SQL Server authentication method. Login account SA

(ii) Open the Configuration Manager to check that the TCP/IP protocol for the Microsoft SQL Server (MSSQLSERVER) is turned on.

Make sure the last SQL Server firewall settings are set correctly, (most of the problems are here)

One, you can directly close the firewall, but this is not safe, do not recommend the use.

Second, to find the Microsoft SQL Server (MSSQLSERVER) TCP/IP protocol. When the SQL Server firewall is already running, click on "TCP/IP Protocol" to select Properties

As we can see from the image above, the TCP/IP protocol on this SQL Server is 1433 ports. The next step is to allow 1433 ports to support the TCP/IP protocol in the configuration of the firewall. Open Control Panel and select Windows Firewall-Advanced settings. Right-click the inbound rules (Inboud Rules) option and select New Rule (newrule):

After you open the new rule option, configure the internal binding protocol for 1433 ports with the new Inbound Rule Wizard to be configured to apply to the TCP/IP protocol.

Configuration process:

After completing the steps above, the SQL Server can support remote links. Try it quickly!

The above is the entire content of this article, I hope you can learn to solve the remote connection problems.