Overview of SQL Reporting Services

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

SQL Reporting Services in Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of Microsoft SQL Server Reporting Services from the Configuration Manager console. Advantages of using this solution include the following:


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

  • Uses an industry standard reporting system to query the Configuration Manager 2007 database.

  • SQL Reporting Services offers higher performance, availability and scalability over existing reporting in Configuration Manager 2007.

  • Enables users who are not familiar with Configuration Manager 2007 reporting to generate ad hoc reports.

  • Enables users to subscribe to reports; for example, a manager could automatically be e-mailed a report each day, detailing the status of a software update rollout.

  • Simplifies the creation of SQL-based reports in Configuration Manager 2007 R2.

  • Enables users to export reports in a variety of popular formats.

Reports can be created in SQL Reporting Services using a number of methods, including the following:

  • By importing existing Configuration Manager 2007 reports into SQL Reporting Services using the Copy Reports to Reporting Services Wizard.

  • By creating new reports using the Create Report Wizard.

  • By using Microsoft Report Builder, supplied with SQL Server.


Using SQL Reporting Services on your site does not replace the existing Configuration Manager 2007 reports.

For more information about installing and configuring SQL Reporting Services, visit the SQL Reporting Services Web site at http://go.microsoft.com/fwlink/?LinkId=111840.

In This Section

See Also


Administrator Checklist for SQL Reporting Services
Planning for SQL Reporting Services
Prerequisites for SQL Reporting Services

Other Resources

Configuring SQL Reporting Services
SQL Reporting Services in Configuration Manager 2007 R2 and Later
Tasks for SQL Reporting Services
Technical Reference for SQL Reporting Services
Troubleshooting SQL Reporting Services

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