SOUSSI Imed Visual LAB : Sharepoint 2010 – Project Server 2010 : N4

Configuring Excel Services / SharePoint 2010 And Configure reporting for Project Server 2010

Configure reporting for Project Server 2010

To add a login for the report authors group

1. Click Start, All Programs, Microsoft SQL Server 2008, SQL Server Management Studio.
2. Select the instance of the SQL Server database engine where your Project Server 2010 reporting database resides, and then click Connect.
3. Expand Security, right-click Logins, and then click New Login.
4. On the General page, click Search.
5. Click Object Types, and select the Groups check box.
6. Click OK.
7. Type the name of the group you created for report authors.
8. Click Check Names.
9. Click OK.
10. Select the User Mapping page.
11. In the Users mapped to this login list box, select the row containing the Project Server 2010 Reporting database.
12. Select the Map check box for the Project Server 2010 Reporting database.
13. Select the db_datareader database role membership check box.
14. Click OK.