Navicat remote Connection SQL Server Express report 08001 Error

Scenario: Navicat remote Connection SQL Server Express report 08001 error, checked firewall port 1434,1433 is already open

Procedure: 1. At first, it is the connection name problem, use the IP address or hostname to connect, and then replace the IP address \ Named instance mode, use the latter better

2. Replace the connection string still error 08001, try to shut down the firewall, the connection is successful, indicating that the problem is now on the port

3. Use the Netstat–ano command to view, found this command too chicken, Internet find tools, found CurrPorts tools, very good, hair one. The software can clearly see the various connection information, especially the remote IP can be seen, which makes it easy to view the ports required for remote connections in case of a firewall shutdown.

4. Discover that the navicat needs to use 9061 ports to open in the firewall and the remote connection is successful.

Navicat remote Connection SQL Server Express report 08001 Error