2.4 Configuring SQL Server Reporting Services

To deploy reports to SSRS and set up email subscriptions, you must first configure SSRS to work with Reporting Center. The ability to deploy reports requires that each account that you use to log in to Reporting Center has corresponding account permissions in SSRS. Specifically, each Reporting Center account must, at a minimum, be designated in SSRS as System User with the Content Manager role.

The ability to set up email subscriptions requires that you configure the SSRS email settings in the Reporting Services Configuration Manager. In addition, for subscriptions, ensure that the SQL Server Agent is running.

For more information about deploying reports, see Section 4.3, Deploying Reports.

For information about configuring SQL Server Reporting Services, review the following sections:

2.4.1 Configuring Report Deployment in SSRS

When you configure report deployment, you first specify an account as System User or System Administrator at the site level. You then assign that account the minimum role of Content Manager.

To enable report deployment in SSRS from Reporting Center:

  1. In a Web browser, go to the SSRS URL, usually in the following location: http://SeverName/Reports

  2. Click Site Settings > Security > New Role Assignment.

  3. Enter the user or group account that deploys reports from the Reporting Center Console to SSRS.

  4. Select a role for that account and click OK.

  5. On the main Reports page, click Home > Properties > New Role Assignment.

  6. Enter the user or group account you just assigned as a System User or System Administrator at the site level.

  7. Select Content Manager and click OK.

2.4.2 Configuring Email in SSRS

If you want to set up a subscription in Reporting Center to deliver your deployed reports by email on a schedule, you must configure the email settings in SSRS. However, if you do not configure email settings in SSRS, then the Reporting Center only provides the option to set up a subscription for report delivery to a file share.

To configure email settings in SSRS:

  1. Open the Reporting Services Configuration Manager and click E-mail Settings.

  2. Specify the email address, SMTP delivery method, and SMTP server information and click Apply.

  3. Click Exit.