May 6, 2016 at 4:42 pm
I have a 2012 instance running on my desktop, and I was messing around with the user account running the SQL Server service (allowed to be the default upon initial setup). I set it to my active directory account, and now I can't get the instance running again. The Event Viewer is claiming that the account password is incorrect. I've tried re-typing it several times, and I couldn't have gotten wrong every time.
I am setup as the administrator on my machine, so, I'm clueless as to why I'm unable to get the instance up & running.
Thanks for the help,
--=Chuck
May 6, 2016 at 4:47 pm
This is the error from the Event Viewer:
The MSSQLSERVER service was unable to log on as AGENCY\smithr with the currently configured password due to the following error:
Logon failure: unknown user name or bad password.
May 6, 2016 at 7:07 pm
Try resetting the password and try again or check the username spelling.A bad username or password or the only reasons Ice ever seen that error. You could also try a local system account if you just want to get up and running.
-- Itzik Ben-Gan 2001
May 9, 2016 at 10:59 am
Odd ... I restarted my computer, and the service started up using the same AD account that was previously throwing the invalid password error, without me having changed my password.
Is there a good document/website detailing the accounts should be used for service accounts, for SQL Server? I'm not clear on when a local account should be used, vs an AD account, especially in cases where network drives need to be accessed.
--=Chuck
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply