locked
PWA Content Database Account Access RRS feed

  • Question

  • Hello All,

    While installing Project Server 2013 on SharePoint 2013 I am at the step of "Configure reporting for Project Web App (Project Server 2013)".

    http://technet.microsoft.com/en-us/library/ee662106.aspx#VideoDemonstration

    I have Project installed, created a separate content database, and verified the URL is working.

    https://sharepoint.mainsite.local/PWA

    In the above article I am at looking over the prerequisites and found the following note:
    "The Excel Services application pool account requires access to the SharePoint content database that is associated with Project Web App. If the content database was created after Excel Services was configured, you must follow the procedure in Grant content database access to the managed account to grant the proper access."

    I created a separate Content database for project and need to grant the excel services app pool account access to it.  In the article it tells me to run:
    $w = Get-SPWebApplication -identity http://<WebApplication>
    $w.GrantAccessToProcessIdentity("<Domain>\<Username>")

    However when I do it says it cannot find the web application -identity https://sharepoint.mainsite.local/PWA.

    The above cmdlet appears to be giving the account access to a webapplication and not a content database.  How do I give the Excel Services app pool account access to my Project Content Database?

    Thanks for any insight...

    Thursday, February 21, 2013 7:13 PM

Answers

  • Hi there,

    That command will give the account access to the content database/s attached to that web application. Don't use the PWA URL just use:

    -identity https://sharepoint.mainsite.local

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

    • Proposed as answer by Alexander.Burton Friday, February 22, 2013 5:28 AM
    • Marked as answer by PWMatherMVP Tuesday, May 27, 2014 7:27 AM
    Thursday, February 21, 2013 7:47 PM