N/APosted on - 09/30/2011
I am being plagued by the error given below by SQL Server agent.
This happens almost every time I restart the server that has been running for a day or two:
Could not start MSSQLSERVER service on Local Computer.
Error 1069: The service did not start due to a logon failure.
The SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Server Agent has changed (password change). What puzzles me is that the login is ok and no changes has been made to it's password.
Can anyone please help me shed a light on this?
I am using SQL2k with SP3a.
Services Error by SQL Server Agent
You're actually right that this issue comes up if the user's logon password has been changed. Although you already confirmed that the password is correct, you may want to check the password in the MSSQLServer Agent as well. To do that, just follow the instructions below.
1. Open Run
2. Type services.msc and click Ok.
3. In the Services window, look for MSSQL$(instance name if you have one locally).
4. Right click on the service name and choose properties.
5. Click on the Log On tab.
6. In this window you have to check whether the password has been changed. Then click ok.
7. Stop the service and start again to ensure that the changes has been applied.
8. Try restarting the server again.
Hope this helps!