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 and select:
4. Start→Control Panel→System and Security→Administrative Tools→Services, start the red box mark in the picture below (started It’s best to restart):
Related recommendations: "Navicat for mysql graphic tutorial"
5. Open SQL Server Configuration Manager;
6. Configure the SQL Server service and start or restart SQL Server:
7. Open the SQL Server network configuration, as shown in the figure:
8. Return to Nativcat to obtain 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 What should I do if navicat reports error 08001 when connecting to sql server?. For more information, please follow other related articles on the PHP Chinese website!
