Grant content database access for managed account via SharePoint 2013 Management Shell

During Configuring the Excel Service in SharePoint Server 2013, I have created a separate domain account to run the Excel Services application pool that has been registered to the Managed Account within Central administration.

configure managed account - Security - Central Administration

The previous step is not sufficient to configure Excel Service, as its prerequisites, you must grant access to the SharePoint content database for the account that will be used to run the Excel Services application pool, and to achieve that follow the mentioned steps below:

  • Navigate to the SharePoint Application Server that will be associated with Excel Services.
  • Open SharePoint 2013 Management Shell as Administrator.

Run SharePoint Management Shell as Administrator - Devoworx

  • Type the following command with your entry.
$w = Get-SPWebApplication -identity http://<WebApplication>
$w.GrantAccessToProcessIdentity("<Domain>\<Username>")

grant content database access to the managed account vis powershell

Note : If you intend to add additional content databases in the future, you must repeate these cmdlets for each new one to ensure that Excel Services has accessd to each new databases.

You can now continue to configure Excel Service in SharePoint 2013.

Enjoy 🙂

Advertisements

2 thoughts on “Grant content database access for managed account via SharePoint 2013 Management Shell

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s