How to Configure Microsoft SQL Server for SQL Reporting Services

Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

Before you can use SQL Reporting Services integration in Configuration Manager 2007 R2, you must configure reporting services on a SQL Server  installation in your network. The configuration steps below apply to SQL Server 2005 and might vary if you are using a newer version of SQL Server. See your SQL Server documentation for details. For a list of supported SQL Server versions, see Configuration Manager Supported Configurations.

Note

The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

To install the SQL Reporting Services component of SQL Server 2005

  1. From the installation media you used to install SQL Server 2005, run setup.exe to start the SQL Server Setup Wizard.

  2. Accept the end user license agreement, and then click Next.

  3. Review the Installing Prerequisites page, and click Next.

  4. After SQL Server Setup performs a configuration check, the Welcome page of the SQL Server Installation Wizard is displayed. Click Next.

  5. Review the results of the system configuration check to identify any problems that might prevent the configuration of SQL Server from finishing successfully. Click Next.

    Note

    If you receive an Edition Change Check warning message, you must reapply any previously applied SQL Server Service Packs after you have finished configuring the software.

  6. On the Registration Information page, enter your name, company name, and product key, and then click Next.

  7. On the Components to Install page, make sure that Reporting Services is selected, and then click Next.

  8. On the Instance Name page, specify a name for the instance of SQL Server you are upgrading. If you are upgrading the default instance of SQL Server, select the Default instance check box, and then click Next.

  9. On the Service Account page, specify the account details that the reporting services service will use to log in. Check the Reporting Services check box to start the reporting services service after setup completes. Click Next to continue.

  10. On the Report Server Installation Options page, verify that the option Install but do not configure the server is selected, and then click Next.

  11. On the Error and Usage Report Settings page, select whether you want to inform Microsoft of any error and usage data for SQL Server, and then click Next.

  12. On the Ready to Install page, review the information shown, and then click Install.

  13. After installation is completed, click Next.

  14. On the Completing Microsoft SQL Server 2005 Setup page, review any information shown, and click Finish to close the wizard.

To configure SQL Reporting Services in SQL Server 2005

  1. From the Windows Start menu, navigate to Microsoft SQL Server 2005 / Configuration Tools, and then click Reporting Services Configuration.

  2. In the Report Server Installation Instance Selection dialog box, specify the name of the server hosting SQL Reporting Services, from the drop-down menu, select the SQL Server instance on which you installed SQL Reporting Services, and then click Connect.

  3. In Reporting Services Configuration Manager, click Server Status. Verify that Service Status is set to Running. If it is not, click Start, and then click Apply.

  4. Click Report Server Virtual Directory, and then click New to specify a new virtual directory.

  5. In the Create a New Virtual Directory dialog box, select Default Web Site from the Website drop-down list, and specify the name you want to call the virtual directory created by Reporting Services (or use the default ReportServer), and then click OK.

  6. Ensure that Apply default settings is selected, and then click Apply.

  7. Click Report Manager Virtual Directory, and then click New to specify a new virtual directory.

  8. In the Create a New Virtual Directory dialog box, select Default Web Site from the Website drop-down list, and specify the name you want to call the Report Manager virtual directory created by Reporting Services (or use the default Reports), and then click OK.

  9. Ensure that Apply default settings is selected, and then click Apply.

  10. Click Web Service Identity. If you do not want to change the defaults in this section, click Apply.

  11. Click Database Setup, select the Reporting Services server you want to use for reports from the Server name drop-down list, and then click Connect.

  12. In the SQL Server Connection Dialog dialog box, specify the SQL Server name and connection details for the Reporting Services server, and then click OK.

  13. On the Database Connection page of Configure Report Server, click New.

  14. In the SQL Server Connection Dialog dialog box, specify a name for the new Reporting Services database (or use the default, ReportServer), and then click OK.

  15. Click Apply to complete configuration of the new database.

  16. Click Email Settings. Specify the following information:

    Note

    If you do not want to use e-mail-based report subscriptions, you do not need to complete this step.

    • Sender Address: Specifies the e-mail address that will appear as the sender address of any e-mail sent from SQL Reporting Services. The account specified must have sufficient permissions to send e-mail from the specified SMTP server.

    • Current Delivery Method: Specifies that the delivery method used to send e-mails will be via SMTP server. This is the only delivery method you can configure through reporting services configuration. For details about configuring other delivery methods, see the SQL Reporting Services documentation.

    • SMTP Server: Specify the name of the SMTP server to use when sending reports. This can be a local or remote server.

    Click Apply.

  17. Click Execution Account. Specify the user name and password of a Windows user account that will be used to run unattended reports—for example, those used by subscriptions. Click Apply.

    Note

    If you do not want to use report subscriptions or if you have configured the option Credentials stored securely in the report server on the Data Source Authentication tab of the Report Server Properties dialog box, you do not need to complete this step.

  18. Click Apply, and then click OK.

  19. Click Exit to close Reporting Services Configuration Manager.

See Also

Tasks

How to Configure Properties for the Reporting Services Point
How to Create a Reporting Services Point for SQL Reporting Services

Concepts

Administrator Checklist for SQL Reporting Services

Other Resources

SQL Reporting Services in Configuration Manager 2007 R2 and Later

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.