You have the option to configure the data source when deploying Active Roles reports to the report server. For more information, see Deploying reports to the Report Server. If you have not configured the data source, or need to change the data source, you can do this by using Report Manager on the report server on which the Active Roles reports were deployed.
To configure the data source by using SSRS Report Manager
-
Start SSRS Report Manager from your web browser.
Report Manager is installed during setup of SQL Server Reporting Services (SSRS) on the same computer as the report server. To start Report Manager, open your web browser and type the Report Manager URL in the browser address bar. By default, the URL is http://<ComputerName>/reports.
-
Perform the following steps on the Contents page that appears:
-
Click Active Roles. The Version and SharedDataResources components are displayed.
-
Click SharedDataSources.
-
Click the data source named Active Roles Report Data.
If the SharedDataSources item is not displayed, click Details View.
-
-
In the Connection string box on the Properties page that appears, specify the database server instance, database type, and the name of the database that holds the report data prepared by the Active Roles Collector.
For example, if the name of the database is ARServerReporting and the database is on the SQL Server instance named MyServer\Enterprise, the connection string is as follows:
data source = MyServer\Enterprise; initial catalog = ARServerReporting
-
Click Apply.