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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment