There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
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.
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.
Asked:
-
2
1 Solution
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?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
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