SQLTeam.com | Weblogs | Forums

SQL Services not starting after reboot


#1

Hello all. I am a systems administrator who is having issues with any sql server that requires a reboot. At first I thought it was patching but now I know even if I do a restart of a machine that has sql on it the services fail to start do to a "log in failure" for an example this particular services is using the NT Service\SQLSERVERAGENT and there is a passowrd in the fields. But after doing some searching on the net I know know that this account does not have a password so I blanked the password field out and was able to start the service. How do I configure this so that this service just starts automatically without trying to put a password in the password field


#2

Check with your Windows Admins to see if there is a policy disabling services on some machines. That's the situation where I work. So like you, I need to reset the passwords on the services after reboot, but only on my laptop. My servers are just fine, since they are in the policy whitelist


#3

I guess I am technically the windows admin. I mean I deal with group policy but I have checked and I have not seen or may overlooked where the policy would cause problems


#4

change the account to a domain account that has admin privileges on the server eg domain\domainAcc then restart the service.....once this starts successfully you can change it back to the NT Service\SQLSERVERAGENT account


#5

before you change it to NT Service be sure to change the startup option to automatic


#6

Ok I can do that but will it I get the same problem when I reboot the server where the services wont start and have to do that every time?


#7

can you use a Domain Account instead?


#8

Im sure we can. I am just wondering why we are using this specific accounts anyway. The explanation that I have recieved is because that these accounts have specific privileges but in my experience you can have a domain account service account to accomplish this


#9

its more to do with domain access (or remote access to other servers) from a sql perspective