Friday, February 17, 2012

Error message 1069

The service did not start due to login failure.
Hi,
It seems the password or user in SQL Server service startup account is
having issues.
What to do:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the service
Do the above steps for SQL Agent service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server service startup which do
not change password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"GDawkins" <GDawkins@.discussions.microsoft.com> wrote in message
news:21D13458-F10F-4A0C-AA6A-29C32C52B54B@.microsoft.com...
> The service did not start due to login failure.

No comments:

Post a Comment