Microsoft project server 2010 reporting database

Sign in to vote. Hello, Could someone please provide me with a link to the Reporting database schema? Friday, September 14, PM. Edited by romilnagrani Monday, February 18, PM. Monday, February 18, PM. Friday, April 12, AM. Step 7 - Archived items. Step 8 - Find and save attachments, views, and VBA files.

The following is an overview of the process to export a specific user's information from Project Web App:. Download the export scripts : Download the.

You can also choose to specify the user claim. Perform an export of the user's data : Export the information that you want to review by using the scipts. While the general process applies to all three versions, there are specifics that may apply to the different versions, especially when running the SQL scripts. These are noted in the sections below. Be sure you have deployed the latest updates to your farm and Project Professional clients. Download the export scripts from the Microsoft Download Center.

Use the scripts for your version or Project Server as described in Step 5, below. The script folder contains several. These are required by the PowerShell scripts. Be sure they are in the same directory as the PowerShell scripts when you run them. The SetupReportingProceduresx. These stored procedures are required by the following scripts:. Each script has one or more variables that must be defined - such as UserID or database name - before you run it.

Check the description section in the script itself for any needed parameters. Run each. Use the domain group you created for report authors. Excel does not use the Secure Store Service for data access. Users working with reports in Excel require direct database access.

Perform the following procedure on the computer where your Project Web App database is located, or connect to the database engine remotely by using SQL Server Management Studio. Expand Security , right-click Logins , and then click New Login.

In the Users mapped to this login list box, select the row containing the Project Server Database. After installing the AMO objects, restart the Project Application Service on each application server in the farm where it is running. In the Trust Children section, confirm that the Children trusted check box is selected.

In the Allow External Data section, select the Trusted data connection libraries and embedded option. In the Warn on Refresh section, clear the Refresh warning enabled check box. You must configure trusted data connection libraries in order to give users access to the connectors that link the report spreadsheets to the data in the Project Server Database and OLAP databases.

On the Data Connections page, click the Open Menu button In the Address box, paste the URL for the data connection library that you copied in the previous procedure. It should be in the following format:. See how to enable scripts. Project Reference: Software Development Kit. The Microsoft Project SDK contains documentation, code samples, "How to" articles, and programming references to help customize and integrate the Project clients and Project Server with other applications for enterprise project management.

Details Version:. File Name:.