Database connection is not parking lot system, how to solve?

2022-04-16 00:00:00

Intelligent parking system in use process will encounter some problems, because the database connection fails, can’t log in the parking lot management software is one of the very headache?General parking system USES a SQL database, we summarized the SQL database connection failure reason and solution, for your reference.

1. The login name, password, server name, the name of the database login error unable to connect, the more common, carefully check the whether the information is correct, fill in the correct general can solve.

tip: when there is a database are using the software can’t connection, the general is the server name appear problem, change the server name usually can solve the problem.Database if it is installed in the machine, the server name can use & other;. Throughout the &;Or & other(local) & throughout;To take the place of;If it is installed on the other computer local area network (LAN), can use the IP address as the server name.

2. If not properly installed SQL server, can also lead to a database connection is not;After installed database, if the SQL service manager has not started, is going to open from the service.

skills: if it is a SQL database has not been able to successfully install, reinstall again, may be can’t install, tip is an unfinished installation hung.Solution method is: open the registry editor, in HKEY_LOCAL_MACHINE SYSTEM CurrentControlSet Control find and remove our SessionManager PendingFileRenameOperations project.

if it is to change the Windows user name or password, can lead to SQL service manager can not start, the solution is to go to the service control section and modify the startup.Concrete is: click start - & gt;Settings - & gt;The control panel - & gt;Management tools - & gt;Service - & gt;Find the MSSQLSERVER service - & gt;Right click on it - & gt;Attributes - & gt;Log in, & gt;Modify the start the service account and password.

3. Unable to connect database caused by permission problems, the solution is to detect the computer security constraints, essentially a security Settings and operating system security restrictions.

skills: can temporarily shut down the firewall or antivirus software first, whether the software security Settings.

is essentially security Settings: open the enterprise manager - & gt;An essentially groups - & gt;Right-click the server name, & gt;Click the properties - & gt;In essentially attributes - & gt;Security, & other;Authentication & throughout;Choice for & other;In essentially and Windows”;

if the SQL server using the WINDOWS xp system, when the workstation computers can not connect to the database, can be in a different server and all workstations the WINDOWS user account and password, the workstation can connect to the database.