Grant SharePoint Content Database Access to a managed account Using PowerShell

In this article, I will show

How to grant content database access to a SharePoint managed account using PowerShell


Scenario

before you are going to Configuring the Excel Service in SharePoint Server 2013, you should first do the following:

  • Create a domain account to run the Excel Services application pool.
  • Register the new account to the Managed Accounts in the Central Administration.

configure managed account - Security - Central Administration

  • Grant access to the SharePoint content database for the account that will be used to run the Excel Services application pool.

Grant content database access to a managed account in SharePoint

  • 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://WebAppURL

$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.


Applies To
  • SharePoint 2013.
Advertisements

2 thoughts on “Grant SharePoint Content Database Access to a managed account Using PowerShell

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s