In this article, I will show
How to grant content database access to a SharePoint managed account using PowerShell
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.
- 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.
- Type the following command with your entry.
$w = Get-SPWebApplication -identity http://WebAppURL $w.GrantAccessToProcessIdentity("domain\username")
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.
- SharePoint 2013.