?
Solved

MS Sql Server service accounts

Posted on 2011-03-15
4
Medium Priority
?
344 Views
Last Modified: 2012-08-14
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.
   
0
Comment
Question by:MnInShdw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 79

Expert Comment

by:arnold
ID: 35144557
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
0
 
LVL 14

Accepted Solution

by:
Daniel_PL earned 2000 total points
ID: 35144938
For best performance it's not recommended to install SQL Server e.g. on domain controller.
But if you want to you can off course. Your service accounts should be domain accounts dedicated to each service. Priviledges will be granted during installation automatically.
Be aware of setting lock pages in memory policy for SQL Server service account on that domain controller, you need to wisely set up max and min server memory to avoid your server memory starving :)

Take care,
Daniel
0
 
LVL 1

Author Comment

by:MnInShdw
ID: 35144970
I had visited these pages before, but it wasn't clear enough (for me).

Would "Domain users" group be enough for the necessary accounts?
0
 
LVL 1

Author Closing Comment

by:MnInShdw
ID: 35144990
Million thanks
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

718 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question