MS SQL Server - SQL service account rights

Author

SQL service account rights

Tom

2005-07-16, 8:23 pm

I have SQL2000 running on a server that is a domain member. It was initially
setup to use a system local account for both services. I changed that and
setup both services to use domain account that is also a member of domain
admin group. Since this account has also local administrator rights it
shouldn't have any problems with NTFS and registry rights. After setting up
this account in services MMC, I get the message that this account now has
"Log on as a service right". SQL services then run OK.

After rebooting the server, SQL services don't start due to a "SQL Server
Service Did Not Start Due to a Logon Failure" error. Than I have to setup
SQL services account again using the same domain username and the same
password. After that point I get the same message that this account now has
"Log on as a service right". Why is this account loosing this right after
reboot? Besides that , everything works OK.

Thanks
Tom

Tibor Karaszi

2005-07-16, 8:23 pm

Are you certain the "logon as a service" is lost. The error suggests to me that you haven't
specified correct password for the account...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Tom" <mcseman2002@hotmail.com> wrote in message news:%23MHR2njiFHA.2852@TK2MSFTNGP14.phx.gbl...
>I have SQL2000 running on a server that is a domain member. It was initially setup to use a system
>local account for both services. I changed that and setup both services to use domain account that
>is also a member of domain admin group. Since this account has also local administrator rights it
>shouldn't have any problems with NTFS and registry rights. After setting up this account in
>services MMC, I get the message that this account now has "Log on as a service right". SQL services
>then run OK.
>
> After rebooting the server, SQL services don't start due to a "SQL Server Service Did Not Start
> Due to a Logon Failure" error. Than I have to setup SQL services account again using the same
> domain username and the same password. After that point I get the same message that this account
> now has "Log on as a service right". Why is this account loosing this right after reboot? Besides
> that , everything works OK.
>
> Thanks
> Tom
>

Tom

2005-07-17, 7:23 am

No, I enter the same password as the first time.
After that I get the message that this account now has "Log on as a service
right" and services start normally.
If I then restart SQL sevices, they start OK. If I restart them the next
day, I get that famous SQL services don't start due to a "SQL Server Service
Did Not Start Due to a Logon Failure" error....

I suspect now that it has something to do with default domain group policy
since it could overwrite local "logon as a service" security policy after
refresh interval. I'm testing that posibility...

Tom

"Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote in
message news:uwNk9zjiFHA.3540@TK2MSFTNGP14.phx.gbl...
> Are you certain the "logon as a service" is lost. The error suggests to me
> that you haven't specified correct password for the account...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
> Blog: http:// solidqualitylearning
.com/blogs/tibor/
>
>
> "Tom" <mcseman2002@hotmail.com> wrote in message
> news:%23MHR2njiFHA.2852@TK2MSFTNGP14.phx.gbl...
>

Sponsored Links