Restart Issue

[jimmythegeek]

We had a power failure a couple weeks ago, and ever since we have had this problem. Our SQL Server is scheduled to reboot itself once a week. It reboots fine, but after it reboots, the MSSQLSERVER service won't start even though it's set to automatic. If we go into the service and RE-TYPE our password, then you can start the services. We don't have to change the password, simply re-type it.

Is there a fix to this so that we don't have to keep manually starting the services by re-typing the existing password? Thanks in advance for any input.

Jim Lunde
We all agree your theory is crazy, but is it crazy enough?

 

[JayKusch]

Check in the Services folder of the server and make sure the SQL Server service is set to start automatically. If not, reset it.

Thanks

J. Kusch

 

[jimmythegeek]

It is set to automatic.

Jim Lunde
We all agree your theory is crazy, but is it crazy enough?

 

[JayKusch]

Look in the Windows Application and System event logs to see if there are any errors as to why the service did not start.

Thanks

J. Kusch

 

[Catadmin]

Check the machine/domain account that the Service is mapped to. Maybe something there got corrupted or just needs some attention before it works again. Also, try re-entering the password in the Services folder instead of the Server Properties window. If there's some sort of "brain fart" on the part of the machine, that may help. Or not.

"This is just another bizarre idea brought to you by the Oumpalumpa Wannabe Fan Club"...

Yeah, I'm having a very weird day. @=)

Hope this helps.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???