Solved

MS Sql Server service accounts

Posted on 2011-03-15
4
320 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
  • 2
4 Comments
 
LVL 77

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 500 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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SqlDataBase 7 48
Get the latest status 8 31
Need some help to cast ntext to nvarchar SQL 2000 7 33
SQL Server - Set Value of Multiple Fields in One Query 10 23
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

770 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