Can not start MSSQL service by normal Windows account

Question

Post reply

Can not start MSSQL service by normal Windows account

thang_ngo_2002

SSCrazy

Points: 2187
More actions
June 5, 2010 at 10:41 pm

#97046

I use Windows account instead of Local System account to start MSSQL service to make more secure. My Windows is stand-alone, not domain system.
It's ok for longtime, but in a beautiful day, after I stop service, I can't start it again, there is error "The MSSQLSERVER service depends on the Net Logon service which failed to start because of the following error: The operation completed successfully", then (I change to Log On by Local System account, it starts OK)
So what's wrong, why I can use Windows account before?
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

As local system works it sounds like a permissions issue.

does the local windows account have logon as a service rights?

---------------------------------------------------------------------

thang_ngo_2002 SSCrazy Points: 2187 More actions · Answer 2

Yes, it can run as service, because I use windows account for long time, but now suddenly this issue happens

george sibbald SSC Guru Points: 104210 More actions · Answer 3

It may have lost some of its rights, so check. Have you tried reenabling the account as the logon account via EM, or a server reboot?

---------------------------------------------------------------------

thang_ngo_2002 SSCrazy Points: 2187 More actions · Answer 4

Could you please explain me detail how to "reenabling the account as the logon account via EM"?

Thanks

george sibbald SSC Guru Points: 104210 More actions · Answer 5

right click server name, select properties, select security tab and amend the startup service account.

---------------------------------------------------------------------

thang_ngo_2002 SSCrazy Points: 2187 More actions · Answer 6

I think this way equals to setup Log On account on screen of Windows services configuration

george sibbald SSC Guru Points: 104210 More actions · Answer 7

no it doesn't, if you do it through EM the account will be assigned all the permissions it needs at the same time. doing it through the services applet does not do that, so you should always assign the service account through EM.

You only got away with it last time because you assigned local admin which has all permissions anyway.

---------------------------------------------------------------------