Article ID: 282254 - View products that this article applies to.
This article was previously published under Q282254
When you restart Microsoft SQL Server or SQL Server Agent, the service may fail to start with the following error message:
Error 1069: The service did not start due to a logon failure.
This problem occurs because the password for the SQL Server startup service account or the SQL Server Agent startup service account is not correct. This problem can occur when the password for the account is changed but the password information was not updated for the SQL Server service or the SQL Server Agent service.
To solve this problem, type the correct password in the Microsoft SQL Server service account on the SQL Server host computer.
To correct the password in Microsoft Windows 2000 Server and Microsoft Windows XP:
Note If you are using SQL Server 2005, see the "Changing passwords and user accounts" topic in SQL Server 2005 Books Online.
The following section is from SQL Server 2000 Books Online:
"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.Using SEM, right-click the Server, click Properties, and then click the Security tab. Under Startup service account, enter the appropriate account and password.
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."
If you are using Kerberos Security Support Provider Interface (SSPI) authentication in a SQL Server 2000 and Microsoft Windows 2000 environment, you must drop your old service principal name (SPN), and then create a new one with the new account information. See the "Security Account Delegation" topic in SQL Server 2000 Books Online for details about using SETSPN to do this.
Article ID: 282254 - Last Review: February 22, 2007 - Revision: 8.3
Contact us for more help