SQL Server Service failed to start due to logon failure _mssql

SQL Server Service failed to start due to logon failure
Symptoms
When you restart SQL Server, SQL Executive, or SQL Server Agent, you may not be able to start the service and display the following error message:

Error 1069:the Service did not start due to a logon failure.
Or
Error 1069: Unable to start service due to logon failure
Reason
The password for the SQL Server, SQL Agent, or SQL Server Executive startup service account is incorrect because the password may have been changed.
Alternative methods
To resolve this issue, type the correct password in the SQL Server host's Microsoft SQL Server service account.

To correct the password in Microsoft Windows Server and Microsoft Windows XP, follow these steps: 1. Click Start, point to Settings, and then click Control Panel.
2. Double-click the Admin tool, and then double-click the service.
3. Double-click MSSQLServer, and then clicking the Login tab.
4. Type the correct password in the password and Confirm password text box, and then 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. Type the correct password in the password and Confirm password text box, and then click OK.
Note: Changing this password through the Services applet will allow SQL Server to reboot successfully, but if you have a Microsoft search (Full-text Search service) installed, it requires subsequent password changes through SQL Enterprise Manager (SEM).

The following section is excerpted from the SQL Server 2000 online book:


"After changing the SQL Server service account information at control Panel, your must also change the SQL Server service A Ccount in SQL Server Enterprise Manager.this allows the service account information for Microsoft Search service to remain Synchronized as.

Important:although The Microsoft Search service is always assigned to the local System account, the Full-text search Engin e tracks the SQL Server service account in Windows.full-text Search and failover clustering are not available if Windows p Assword changes are not reset using SQL Server Enterprise Manager. " (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.) In this way, the service account information for the Microsoft Search service is also kept synchronized. 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. If you do not use SQL Server Enterprise Manager to reset Windows password changes, you cannot use Full-text search and failover clustering. ）


By using SEM, right-click the server, click Properties, and then click the Security tab. Under Start the service account, enter the appropriate account and password.

When you install SQL Server2000, you use the default logon user as the account to start the SQL Server service (usually the administrator for the stand-alone computer that you are using), but I changed the username "failed to start service with logon failure" error The following methods I have tried.

1, change the user password back to the original, and then start the service
2, using the control Surface Service Manager, find the MSSQLServer service, change the startup account information, changed to change, and then start the service
3, is also the recommended method, create a new user, specifically to start the SQL Server service, the installation of SQL Server to use the user to start SQL Server, so you can avoid the frequent changes to the administrator password with the 1069 error. If you have installed SQL Server, you can also change the service account information for the MSSQLServer service under the control Surface Service Manager and replace it with a user dedicated to the SQL service.


First, we introduce two common solutions on the network:

1. My Computer--control Panel--management tools--services--right key mssqlserver--properties--landing--Landing identity--Select "Local System Account"

Or:

2. My Computer--control Panel--management tools--services--right key mssqlserver--properties--landing--Landing identity--select "This Account"--Password and Confirm password to enter your modified administrator password.

The difference between the two:

Choose the first way, later modified the administrator password, no more adjustments (but require the system administrator to log on to the operating system)

Select the second way, later modified the administrator password, but also repeat the above operation.

Here's one of the things I've encountered:

This morning my colleague told me that his SQL could not log into his "Enterprise Manager". The reported error is "1069 error, because the login failed to start the service", the Internet to find the above two scenarios, but when I saw the service window and found a possible cause of this problem, the following figure:

We first find the MSSQLServer service, and then look at its properties

Discovery uses a domain account to authenticate when starting a service. Then asked whether the password to change the login domain, get the answer is modified, because the domain has been set, a certain period after the user to change the password, and can not be the same password before (empty password, this I have done experiments ^_^). Then the password is reset here, then restart the service successfully, SQL can also log on successfully.

This problem found that when the password of the domain was modified, the login authentication information used by the corresponding service will not be updated automatically and need to be updated manually to resolve the problem. If everyone is more troublesome, it is simpler to modify the login status directly to the local system account as the above solution.