SQL Reporting Services Configuration
Introduction
You can define SQL Reporting Services (SRS) templates that define all the necessary Report Server information (URL and credentials) and Change Auditor data source information for publishing reports. These templates can then be made available to users who choose to publish reports to SRS. That is, when an authorized user attempts to publish a report to SRS using the Publish reports to SQL Reporting Services right-click command on the Searches page, they can use the Import SRS Settings button on the Reporting Services Setup dialog to import the settings defined in a SQL Reporting Services template to publish their reports.
SQL Reporting Services Page
The SQL Reporting Services page is displayed when SQL Reporting Services in the Configuration task list is selected in the navigation pane of the Administration Tasks tab. From this page you can launch the SQL Reporting Services wizard to define the reporting services and data source information needed to publish reports to SRS. You can also edit existing templates, disable/enable templates and remove templates that are no longer being used.
The SQL Reporting Services page contains an expandable view of all the SQL Reporting Services templates that have been previously defined. To add a new template to this list, use the Add tool bar button. Once added, the following information is provided for each template:
Template Displays the name assigned to the template when it was created.
Status Indicates whether the template is enabled or disabled.
URL This field is used for filtering data.
Authorized Accounts This field is used for filtering data.
URL Displays the Report Server URL specified in the wizard.
Database Displays the Data Source name of the database as specified in the wizard.
Authorized Account Displays the accounts that are authorized to use this SQL Reporting Services template.
SQL Reporting Services Templates
To create a SQL Reporting Services template:
1 Open the Administration Tasks tab and select Configuration.
2 Select SQL Reporting Services in the Configuration task list to open the SQL Reporting Services page.
3 Use Add to start the SQL Reporting Services wizard to define the report server and data source information.For example: http://<SQL_Server>/<ReportServer>
where: <SQL_Server> is the name of the server hosting SRS and <ReportServer> is the name of the report server virtual directory. (In a default Reporting Services installation, the name of the virtual directory is reportserver.)
▪ Click Test to verify the credentials entered above.
NOTE: The user and group accounts entered on this page are the ONLY accounts that are allowed to import the settings in this template to publish Change Auditor reports to SRS. For example, the first time an authorized user selects the Import SRS Settings button on the Reporting Services Setup dialog, the Change Auditor Administrators will not be able to import the settings in this template to publish reports to SRS unless they are also added as an authorized account on this page.Use the Browse or Search pages to locate and select the accounts to be included in the template. Use the Add button to add these accounts to the list box at the bottom of the page.
6 Select Finish to create the template and return to the SQL Reporting Services page.Now when an authorized user attempts to publish a report to SRS using the Publish reports to SQL Reporting Services right-click command on the Searches page, they can use the Import SRS Settings button on the Reporting Services Setup dialog to import the settings defined in this template to publish their reports.
To modify a template:
3 Click Finish.To disable a template:
▪The entry in the Status column for the template will change to ’Disabled’.
2To delete a template:
1 On the SQL Reporting Services Auditing page, select the template to delete and select Delete | Delete Template