SQL Reporting Services in Configuration Manager 2007 R2 has external dependencies and dependencies within the product.

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

Dependencies External to Configuration Manager 2007

The following table describes the external dependencies for SQL Reporting Services running in Configuration Manager 2007.

Because of schema changes in SQL Server 2008, you cannot deploy report models created by using this version to the Configuration Manager console. If you have created report models by using SQL Server 2008, you must access them by using your SQL Reporting Services Web site.

Dependency More Information

A Microsoft SQL Server 2005 Reporting Services reporting server must be installed and configured in the site hierarchy.

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.

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.

For more information about configuring SQL Reporting Services for integration with Configuration Manager 2007 R2, see How to Configure Microsoft SQL Server for SQL Reporting Services.

SQL Reporting Services requires Internet Information Services (IIS) 6.0 or later for the Reporting Services Web site.

For more information about installing Internet Information Services, see your Windows Server documentation.

Report model authoring requires the SQL Server Business Intelligence Development Studio component of Microsoft SQL Server.

For information about installing this component, see About Report Models in SQL Reporting Services

Configuration Manager 2007 Dependencies

The following table describes the dependencies within Configuration Manager 2007 for running SQL Reporting Services.

Dependency More Information

The site server must be running Configuration Manager 2007 R2.

SQL Reporting Services requires Configuration Manager 2007 R2.

Remote Configuration Manager consoles must be upgraded to Configuration Manager 2007 R2.

For SQL Reporting Services features to be displayed in remote Configuration Manager consoles, Configuration Manager 2007 R2 Setup must be run to upgrade the Configuration Manager consoles.

Reporting services point site system role.

The reporting services point site system role must be configured before you can use SQL Reporting Services.

For more information about configuring the reporting services point site role, see How to Create a Reporting Services Point for SQL Reporting Services.

See Also