Reasons for database connection failures and how to resolve them __ database

A variety of business systems in the use of the process will encounter some problems, because the database connection failed, can not log in to the management software is one of them, this is a very difficult and common problems

The general business system is a SQL database, we summarized the reasons for the failure of SQL database connection and solutions:

reason one: login account, password, server name, database name login error caused can not connect, this is more common, carefully check the information is correct, fill in the correct general can be solved.

Workaround: When the software that is being used appears to be unable to connect to the database, the server name is generally a problem, and changing the server name can generally solve the problem. If the database is installed on this computer, the server name can be used with "." or "(local)" instead; If you are installing on another computer on your LAN, you can use the IP address as the server name.

reason two: If the SQL Server is not installed correctly, it will also cause the database to be disconnected, and if the SQL Service Manager does not start up after the database has been installed, go to the service to open it.

WORKAROUND: If the SQL database fails to install successfully, reinstall again, it may not be installed, prompting the existence of an unfinished installation pending. The workaround is: Open Registry Editor, HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager to locate and delete the PendingFileRenameOperations project.

If you change the user name or password for Windows, the SQL Service Manager will not start, and the solution is to modify the startup in the service where the layout is being controlled. Specifically: Click Start--> Settings--> Control Panel--> admin Tools--> Service--> find MS SQL Server service--> on top right--> attribute--> login--> Modify startup service account and password.

reason three: The database cannot be connected because of permission problems, and the solution is to detect the security restrictions on the computer, SQL Server security settings, and operating system safety limits.

Workaround: You can temporarily turn off the firewall or antivirus software to see if it is the security settings of these software.

SQL Server security settings: Open Enterprise Manager--> Expand sq L Server group--> Right-click the server name--> click Properties--> in SQL Server Properties--> security, select Authentication as "in SQL Server and Windows ";

If the SQL Server is using a Windows XP system, when the workstation computer appears unable to connect to the database, you can create an identical Windows user account and password on the server and workstation.

reason four: Cause: The network connection has the breakdown;

Workaround: Repair the network for failure.

June 12 Soft text