Navicat sqlserver2016 08001

Environment:

WINDOWS10 (host is Lenovo)

SqlServer2016

Navicat11

Error:

Start SQL Server Various services, port 1433 Yes, Navicat 08001 error when connecting

Analysis:

Dragon Boat Festival before the holiday, or normal use, the festival will be the server power outage, after the restart of the server, not connected. This should not happen because SQL Server's service settings are automatically started and none of the settings have been modified.

Before the office changed the server to the second floor, there has been a case of IP automatically changed, from 192.168.1.100 to 192.168.1.103, the IP navicat the connection setting is replaced by 192.168.1.103.

But this time what settings have not changed, start navicat connection 08001 error ;

Startup control console appears com.microsoft.sqlserver.jdbc.SQLServerException: TCP/IP connection to host 192.168.1.103 via port 1433 failed. the error

Does Lenovo's IP change again? Check it out and really change back to 100.

Solve:

This server as the host IP set to fixed IP : 192.168.1.103, restart the SQL Server service, Navicat re-connect successfully.

Summary:

There may be two reasons why a problem is rare on the web, either it is too difficult or the problem is too simple .... Oh, = =

Navicat sqlserver2016 08001