How to solve the problem that the SQL database connection is not available?

This article introduces the relevant knowledge of "how to solve the problem of SQL database connection". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Solutions: 1, check whether tcp/ip is enabled, and pay attention to the port number; 2, check network problems; 3, use the telnet command to check the port situation; 4, check the server entry, user name password is correct; 5, check whether the server allows remote connection; 6, start two authentication modes.

The operating environment of this tutorial: windows7 system, sql server 2008 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 content of "how to solve the problem of SQL database connection" is introduced here. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!