Shulou(Shulou.com)05/31 Report--

This article mainly explains the "sql can not connect to the server solution", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn the "sql can not connect to the server solution"!

Solution: 1, check whether tcp/ip is enabled, and pay attention to the port number; 2, check the network problem; 3, use the telnet command to check the port; 4, check the server item. Whether the user name and password is correct; 5. Check whether the server allows remote connections.

The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.

When you cannot connect to the database, check the following:

1. Network situation. Check that tcp/ip is enabled and note the port number.

Open the SQL SERVER configuration Manager and check the network configuration

2. Ping server address, check for network problems.

3. Use the telnet command to check the port condition.

If there is a problem with the network, check the firewall settings, or turn it off first.

4. Check the server item. Whether the username and password is correct.

5. Whether the server allows remote connections. After logging in with windows verification, check to find the security-> login name-> login user name-> right attribute, and click status:

6. Right-click Server name-> Properties-> Security to start two authentication modes

The above solves the problem of unable to connect to the database.

Thank you for your reading, the above is the "sql can not connect to the server solution" content, after the study of this article, I believe you can not connect to the server sql solution to this problem has a deeper understanding, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.