Shulou(Shulou.com)06/01 Report--

Learn how to solve the problem of navicat connection sql server reporting 08001 error? This problem may be often seen in our daily study or work. I hope you can gain a lot from this article. Here is the reference content brought by the editor. Let's take a look at it!

1.SQL Server-New connection, verification is divided into two ways: "SQL Server authentication" and "Windows authentication". During the installation of SQL Server, "Windows authentication" is the default option, or you can choose these two common methods. "SQL Server authentication" is not a separate option.

two。 However, when using Windows Authentication connection test, an error occurs as shown in the following figure:

3. Instead of entering the host name or IP address manually, click the button on the right of the box to select:

4. Start the → control panel → system and the security → management tool → service, and start it at the red box marked in the following figure (it is best to restart it once it has been started):

5. Open the SQL Server configuration Manager

6. Configure the SQL Server service to start or restart SQL Server:

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

8. Go back to Nativcat to get the value of the host name or IP address, as shown in the figure:

9. Test the connection, OK.

Thank you for reading the above content, do you have a general understanding of the article "how to solve the problem of navicat connection sql server report 08001 error"? I hope the content of the article will be helpful to you. If you want to know more about the content of the article, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.