Reasons and solutions of database connection failure

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

General business systems are based on SQL database, we summarize the reasons for SQL database connection failure and solutions:

Reason one: login account number, password, server name, database name login error caused the connection, this is more common, carefully check the information is correct, fill in the correct general can be resolved.

Workaround: When the software in use occurs when the database is unable to connect, the server name is generally a problem, changing the server names can generally solve the problem. If the database is installed on this computer, the server name can be used "." or "(local)" instead ; if it is installed on another computer on the 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 connection is not connected; After the database is installed, if the SQL Service Manager does not start, then go to the service to open.

Workaround: If the SQL database failed to install successfully and re-install again, you may be unable to install, prompting for an incomplete installation hang. The workaround is to open the Registry Editor and Locate and remove the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager in the PendingFileRenameOperations Project can be.

If you change theWindowsUser name or password will causeSql Service Manager does not start , The solution is to control the layout of the service where the modification starts. Specifically: Click Start --> set -->< Span style= "COLOR: #333333" > Control Panel --> management tool --> service --> find ms sql server service -->-->--> landed --> Modify the account and password to start the service.

Reason three: Because of permissions issues, the database cannot connect, the workaround is to detect the computer security restrictions,SQL Server security settings, operating system security limits.

Workaround: You can temporarily turn off the firewall or anti-virus software to see if the security settings of these software are caused.

SQL ServerSecurity settings: Open Enterprise Manager- expand sq l server Group --> Right-click the server name -->< Span style= "COLOR: #333333" > Click Properties --> in sql server property --> security, put " authentication " Select to " sql server and Windows ";&NBSP;

If your SQL server is using a Windows XP System, you can create the same Windows user account and password on the server and workstation when the workstation computer fails to connect to the database.

Reason four: cause : network connection is defective ;

• Workaround : There is a failure in overhauling the network.

Reasons and solutions of database connection failure