none
Reporting Database Service Account RRS feed

  • Question

  • We need to extract project & task data from our PWA reporting tables & views into another SQL database where we aggregate and format it for integration with another IT system.

    We've been told by our Microsoft consultant that adding a read-only account to our PWA reporting database enabling us to create a linked server to our PWA database on our other SQL server is not allowed. Instead, we've been told that we need to use PSI to extract the data from our PWA, store the data in a SharePoint List or PowerPivot file, and then import the data from there into the other SQL database.  We've tried this, but it is a very slow and inefficient method of extracting data from our PWA reporting database.

    Can someone from the Microsoft Project Server team confirm that adding an account with read-only access to the reporting tables & views in order to enable access from other SQL databases is an issue and is not acceptable/allowed?

    Monday, August 22, 2016 6:47 PM

All replies

  • Have you looked into leveraging the Report Authors group?  See the section "Accounts and Security Groups" here https://technet.microsoft.com/en-us/library/ee662106.aspx.

    Disclaimer - Any postings are provided “AS IS” with no warranties and confer no rights. The inclusion of any link does not imply endorsement by Microsoft of the linked site.  Comments by this author do not represent official Microsoft policy.

    Tuesday, August 23, 2016 3:22 PM