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

This article will explain in detail the reasons for the failure of the database connection. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Database connection failure reasons and solutions: 1, login account, password, server name, database name login error, should be entered correctly; 2, failed to install the SQL server, should be installed correctly; 3, network connection failure, should check whether there is a fault in the network.

The causes and solutions of database connection failure:

Reason 1: login account, password, server name, database name login errors lead to unable to connect, this is more common, carefully check whether the information is correct, fill in the correct generally can be solved.

Solution: when the software being used can not connect to the database, it is generally a problem with the server name, and changing the server name can generally solve the problem. If the database is installed locally, the server name can be "." Or "(local)" instead; if it is installed on another computer on the LAN, you can use the IP address as the server name.

Reason 2: if the SQL server is not installed correctly, the database will not be connected; after the database is installed, if the SQL service manager is not started, go to the service to open it.

Solution: if the SQL database is not installed successfully, it may not be installed when you reinstall it again, indicating that there is an incomplete installation pending. The solution is to open the registry editor and find and delete the PendingFileRenameOperations entry in HKEY_LOCAL_MACHINE\ SYSTEM\ CurrentControlSet\ Control\ Session Manager.

If you change the user name or password of Windows, it will cause the SQL service manager to fail to start. The solution is to go to the service that controls the layout to modify the startup.

The details are as follows: click start-> Settings-- > Control Panel-- > Administrative tools-- > Services-- > find the MS SQL SERVER service-- > right-click-- > Properties-- > Log in-- > change the account and password to start the service.

Reason 3: the database can not be connected due to permission problems, and the solution is to test the computer's security protection restrictions, SQL Server security settings, and operating system security limits.

Solution: you can temporarily turn off the firewall or antivirus software to see if it is caused by the security settings of these software.

SQL Server Security Settings: open Enterprise Manager-- > expand SQL Server Group-- > right-click the server name-- > Click Properties-- > in SQL Server Properties-- > Security, select "Authentication" to "in SQL Server and Windows"

If the SQL server uses the Windows XP system, when the workstation computer cannot connect to the database, you can establish the same WINDOWS user account and password on both the server and the workstation.

Reason 4: cause: network connection failure

Solution: check whether there is a fault in the network.

This is the end of this article on "what are the reasons for database connection failure". I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, please share it for more people to see.

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.