SQL Server cannot be started properly

SQL Server cannot be started properly

SQL server cannot be started properly

By using SEM, right-click the server, click Properties, and then click the Security tab. Enter the corresponding account and password under the startup service account.

When installing SQL Server, the default login user is used as the account for starting the SQL Server service (for the standalone that you use, it is usually the administrator ), however, if I change the user name, the error "cannot start the service due to logon Failure" appears. The method I have tried is as follows.

1. Change the user password back to the original one, and then start the service.
2. Use the Service Manager of the Control Panel to find the MSSQLSERVER service, change the startup account information, change it to the changed one, and then start the service.
3. It is also recommended to create a new user dedicated to starting the SQL Server service. This user is used to start SQL Server when installing SQL Server, this avoids the 1069 error caused by frequent changes to the administrator password. If you have installed SQL Server, you can also change the service account information of the MSSQLSERVER service under the service manager of the Control Panel to a user dedicated to the SQL service.

First, we will introduce two common solutions on the network:

1. My computer -- control panel -- Management Tools -- service -- Right-click MSSQLSERVER -- properties -- login identity -- select "Local SYSTEM account"

Or:

2. my computer -- control panel -- Administrative Tools -- service -- Right-click MSSQLSERVER -- properties -- login identity -- select "this account" -- enter your modified administrator password in the password and Confirm Password.

Differences between the two:

Select the first method. The administrator password will be changed later. You do not need to adjust the password (but the system administrator is required to log on to the operating system)

Select the second method, modify the administrator password later, and repeat the above operation.

Below is a situation I have encountered:

This morning, my colleague told me that his SQL statement could not be logged on to his "Enterprise Manager". The error "1069 error, unable to start the service due to logon Failure" was reported ", I found the above two solutions on the Internet, but when I saw the service window, I found another location that may cause this problem, such:

First, find the MSSQLSERVER service and view its properties.

It was found that the domain account was used for verification when the service was started, so I asked if I had modified the password of the login domain. The answer was changed because the domain was set, after a certain period of time, the user is required to change the password, and cannot be the same as the previous password (except for the blank password, this is my tutorial ^_^ ). Therefore, you can reset the password and restart the service. You can also log on to SQL.