Link to home
Start Free TrialLog in
Avatar of MnInShdw
MnInShdwFlag for Japan

asked on

MS Sql Server service accounts

I am going to installing SQL Server 2008 on a domain controller.
What account should I use for the services? and what the privileges of each account should be?

Should I use the NT AUTHORITY/SYSTEM account for all services?


many thanks.
   
Avatar of arnold
arnold
Flag of United States of America image

Usually the domain account has to have the right to:
lock pages in memory
Log on as service

http://msdn.microsoft.com/en-us/library/ms144228.aspx
And from the above link: http://msdn.microsoft.com/en-us/library/ms143504.aspx
ASKER CERTIFIED SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MnInShdw

ASKER

I had visited these pages before, but it wasn't clear enough (for me).

Would "Domain users" group be enough for the necessary accounts?
Million thanks