SQL logon service not starting due to logon password

Twice this week I've had to renter the password for the SQL server (MSSQLSERVER) AND (SQLEXPRESS2012).  What would cause this and how do I stop it from happening again?

It's a 2008 R2 VM on a 2012 R2 Hyper-V host.
J.R. SitmanIT DirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
Does this issue happen the first time? I think you do have to ensure the relevant Sql service is started properly.
0
J.R. SitmanIT DirectorAuthor Commented:
The services were running fine all day.  Sometime in the night they stopped.  When I reentered my password, they start just fine.
0
HuaMin ChenProblem resolverCommented:
There could be problem with the setup. I think you can do the same setup, within another Win 2008 R2 server, as a parallel server, which is for testing purpose, and also as another backup.
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

J.R. SitmanIT DirectorAuthor Commented:
This server has been in production for 4 years.  so there isn't a problem with the setup.  Nothing has changed.  It's been running fine until now.
0
HuaMin ChenProblem resolverCommented:
This is why I suggest you have one other VM as a backup and also for testing.
0
J.R. SitmanIT DirectorAuthor Commented:
Thanks, but that doesn't answer my question.  

It looks like the "log on as a service" is the problem.  See attached.  I can't edit it.    I'm logged on as Administrator
logon.jpg
0
J.R. SitmanIT DirectorAuthor Commented:
Had to ad the MSSQL$SQLEXPRESS2012 to the "log on as a service"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Your issue is two-fold. First, why do the SQL services stop? Second, it looks like the "log on as a service" privilege gets lost at some time, so I don't think manually setting it will be persistent. Setting the password does not "override" the privilege, the service cannot start without it. I suspect further issues not revealed yet.
0
J.R. SitmanIT DirectorAuthor Commented:
@Qlemo.  You are correct, changing the password was only temporary.  We change the Logon to the "Local account".
Do you now how to edit the "log on as a service"?  When I tried it using Secpol.msc it wouldn't let me add an account.  When I tried to edit the Domain Policy in the GPO, I could find the account MSSQL$SQLEXPRESS2012 to add it.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
If you switch to Local System, you should not need to set the service login priv.
Using SecPol is correct, IIRC. Were you not able to change anything, or the change is not taken over, or what is the issue?
0
J.R. SitmanIT DirectorAuthor Commented:
see my post 40984765.  It wouldn't let me make changes.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The only reason I know of that you weren't able to set the "Login as Service" privilege is that you did not start secpol.msc as admin.
0
J.R. SitmanIT DirectorAuthor Commented:
I just started it as Administrator and still can't edit it.
0
J.R. SitmanIT DirectorAuthor Commented:
figured it out myself.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.