The SQL Server service cannot be started due to logon failure.

The SQL Server service cannot be started due to logon failure.
Symptom
When you restart SQL Server, SQL Executive, or SQL Server Agent, the Service may fail to be started and the following error message is displayed:

Error 1069: the service did not start due to a logon failure.
Or
Error 1069: unable to start the service due to logon Failure
Cause
The password of the SQL Server, SQL Agent, or SQL Server executive startup service account is incorrect because the password may have been changed.
Alternative Method
To solve this problem, type the correct password in the Microsoft SQL Server Service Account of the SQL server host.

To correct the password in Microsoft Windows 2000 Server and Microsoft Windows XP, follow these steps: 1. Click Start, point to settings, and then click Control Panel.
2. Double-click the management tool and double-click the service.
3. Double-click MSSQLServer and click the logon tab.
4. In the password and Confirm Password text box, type the correct password and click OK.
To correct the password in Microsoft Windows NT 4.0, follow these steps: 1. Click Start, point to settings, and then click Control Panel.
2. Double-click the service and then double-click MSSQLServer.
3. In the password and Confirm Password text box, type the correct password, and click OK.
Note: small servicesProgramChange the password so that SQL Server can be restarted successfully. However, if Microsoft Search (full-text search service) is installed, it requires subsequent password changes through SQL Enterprise Manager (SEM.

The following section is taken from SQL Server 2000 online books:

"After changing the SQL Server service account information in Control Panel, you must also change the SQL Server service account in SQL Server Enterprise Manager. this allows the service account information for Microsoft Search Service to remain synchronized as well.

Important: although the Microsoft search service is always assigned to the local system account, the full-text search engine tracks the SQL Server service account in windows. full-text search and Failover clustering are not available if Windows Password changes are not Reset using SQL Server Enterprise Manager. "(after changing the SQL Server service account information in the control panel, you must also change the SQL Server service account in SQL Server Enterprise Manager. In this way, the service account information used for the Microsoft Search Service will also be synchronized. Important: Although Microsoft search is always assigned to a local system account, full-text search engines track SQL Server service accounts in windows. If you do not use SQL Server Enterprise Manager to reset Windows Password changes, you cannot use full-text search and Failover clusters .)

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.

After the domain password is changed, the login verification information used by the corresponding service is not automatically updated and needs to be updated manually. If you are too troublesome, it is easier to change your login identity to a "Local SYSTEM account" just like the solution above.