This is an attempt to clarify mostly for myself on how to install SharePoint 2010 with best practice/least privilege. It is always tempting to give full access to all your installation accounts and just keep on trucking. At some point this approach might come back and bite you.

SharePoint will elevate the following accounts as necessary during installation.

MyDomain\sp_admin
This account will be used as the installation account(white wizard). This account will also run the timer service and User Code Host service on the server.
AD/local permissions:

  • MyDomain\domain users
  • local\admin (On installation server)

SQLserver roles:
Create a new login in SQL Server Management Studio for the sp_admin account assign the following rights.

  • securityadmin
  • dbcreator

Logon as a service right(GPO):
Give the user Logon as a service right, this can be done through your domain controller or locally on the server.

  • The MyDomain\sp_admin account must be given the logon as a service right on the server running SharePoint.

Start -> Administrative Tools -> Group Policy Management


 MyDomain\sp_farm
This account will be used for DB connection(grey wizard).  This account only need MyDomain\domain users rights, will be elevated as necessary on installation(Installation account will take care of that).
AD/local permissions:

  • MyDomain\domain users

This account will be used for the following services:

  • Windows SharePoint Services Timer V4
  • Windows SharePoint Services User Code Host V4
  • Application Pool SharePoint Central Administration
  • Topology Web Service
  • Security Token Service(Claims )

This account also needs batch logon rights(GPO)

  • See description of setting the GPO above, Log on as a batch job is just above Log on as a service.

SP_ServiceApp
This account is used when creating new Service Applications in SharePoint 2010.
AD/local permissions:

MyDomain\domain users

  Application Pools

How to deal with new application pools?
Some say that you should make a new new account for every application pool. Seems like an overkill that are not practical.

Sp_AppPool_YourNameHere
AD/local permissions:

MyDomain\domain users

How many application pools do you need?
Testing has shown that you should keep your application pools to a minimum to preserve resources. Creating a new dedicated application pool is not recommended from a performance perspective, it will drain a lot of RAM from your box.

Trouble shooting

  • If IIS gives you get an Event ID: 5059 Error you need to give your application pool account batch logon rights

Sources
I did not figure out this by myself, there is a lot of smart people out there.

http://msmvps.com/blogs/shane/archive/2010/07/15/what-service-accounts-do-you-need-to-install-sharepoint-2010.aspx

http://www.amazon.com/Professional-SharePoint-2010-Administration-Klindt/dp/0470533331/ref=sr_1_1?ie=UTF8&s=books&qid=1280416318&sr=8-1

Advertisements