MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Course Of The Month
8 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MS Sql Server service accounts
Posted on 2011-03-15
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.
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.
[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
Active today
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
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
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
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
I had visited these pages before, but it wasn't clear enough (for me).
Would "Domain users" group be enough for the necessary accounts?
Would "Domain users" group be enough for the necessary accounts?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK():
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
Introduction
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses
Course of the Month8 days, 9 hours left to enroll
734 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.