Export (0) Print
Expand All

Prerequisites for SQL Reporting Services

Updated: April 1, 2011

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

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

noteNote
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.

ImportantImportant
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 or later 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, see the SQL Server 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

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft