SQL service account need admin rights?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sas - 28 Mar 2007 01:18 GMT

Does the SQL Service engine account need administrative rights on SQL Server
2005? I know that it is not required on SQL 2000 but not sure on SQL 2005
(not a cluster).

Thanks

System Eng.
MSc in CS, MCSE4, ITIL, IBM Certified MQ 5.3 Administrator
"I saw it work in a cartoon once so I am pretty sure I can do it."

Reply to this Message

Sue Hoegemeier - 28 Mar 2007 03:05 GMT

No....there are some situations where the SQL Agent service
needs administrative rights on server and in those cases
you'd want to consider separate accounts for the two
services.
It's documented in books online under Service Accounts.
http://msdn2.microsoft.com/en-us/library/ms143691.aspx
Check the section: Use a domain user account

And also check: Setting Up Windows Service Accounts
http://msdn2.microsoft.com/en-us/library/ms143504.aspx

-Sue

>Does the SQL Service engine account need administrative rights on SQL Server
>2005? I know that it is not required on SQL 2000 but not sure on SQL 2005
[quoted text clipped - 5 lines]
>MSc in CS, MCSE4, ITIL, IBM Certified MQ 5.3 Administrator
>"I saw it work in a cartoon once so I am pretty sure I can do it."

Reply to this Message