How to solve error 08001 when navicat connects to sql server

1. SQL Server - Create a new connection. There are two verification methods: "SQL Server Verification" and "Windows Verification". "Windows Verification" is the default selection during the installation of SQL Server. item, you can also choose these two common methods, "SQL Server Authentication" is not available as a separate option.

2. However, when using the "Windows Verification" connection test, an error message appears as shown below:

3. The host name or IP address is not entered manually, but Click the button on the right side of the box to select:

Related recommendations: "Navicat for mysql usage graphic tutorial"

4. Start → Control Panel→System and Security→Administrative Tools→Services, (or right-click My Computer→Management→Services and Applications→Services) and start the red box mark in the picture below (it is best to restart if it is already started):

5. Open SQL Server Configuration Manager;

6. Configure SQL Server service, start SQL Server or Restart:

7. Open the SQL Server network configuration, as shown in the figure:

8. Return to Nativcat gets the value of the host name or IP address, as shown in the figure:

9. Test connection, OK;

The above is the detailed content of How to solve error 08001 when navicat connects to sql server. For more information, please follow other related articles on the PHP Chinese website!