You must provide the correct database privileges for SQL Reporting Services to properly connect
and access the AgilePoint database. Follow the steps below to configure the database privileges
after installing Enterprise Manager with SQL Server Reporting Services integration.
-
Open
Microsoft SQL Server
>
Reporting Services
>
Report Manager
and click the
AgilePoint
link
- In the AgilePoint folder, click the APDS item to configure the sample reports data source.
- Make sure the option Use as Windows Credentials when connecting to the data source is checked.
- Click Apply to save the changes.