Before you can use SQL Reporting Services in Configuration Manager 2007, you must configure a reporting services point. The reporting services point is a site system role that must be configured on a server running Microsoft SQL Server with the Reporting Services component installed. For more information about configuring Reporting Services in SQL Server, see How to Configure Microsoft SQL Server for SQL Reporting Services.
|The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.|
Use the following procedure to create a reporting services point on a Configuration Manager 2007 site system.
|When you install a SQL Reporting Services Point, Configuration Manager 2007 queries Windows Management Instrumentation (WMI) for installed instances of SQL Reporting Services. The report folder is installed on the first instance of SQL Reporting Services found by the WMI query. If you have installed multiple instances of SQL Reporting Services and are unsure about whether the instance on which you want to install the report folder is the first stored in WMI, it is recommended that you install the SQL Reporting Services Point on a computer running only one instance of SQL Reporting Services.|
To create a reporting services point
In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Site Management / <site code>-<site name> / Site Settings / Site Systems.
Determine whether to create a new site system or to add the reporting services point site role to an existing site system, and then follow the associated step.
To create a new site system and add the reporting services point role:
- Right-click Site Systems, click
New, and then click Server.
- On the General page of the New Site
Role Wizard, specify the name of the server that will be used to
host the reporting services point.
To add the reporting services point role to an existing site system:
- Right-click the site system name, then click
- Right-click Site Systems, click New, and then click Server.
On the General page of the New Site Role Wizard, configure the general settings for this site system, and then click Next. For information about the options you can specify on this page, see How to Add New Site System Roles. Click Next.
On the System Role Selection page of the wizard, select Reporting Services point, and then click Next.
On the Reporting Services Point page, specify the folder that will be created on the report server to contain the SQL Reporting Services reports used in Configuration Manager and then click Next.
Note The default name for this folder is Reports.
Review the information shown on the Summary page, and then click Next.
Click Close to exit the wizard.
TasksHow to Add New Site System Roles
How to Configure Microsoft SQL Server for SQL Reporting Services
How to Copy Configuration Manager Reports to SQL Reporting Services
ReferenceReport Options Dialog Box
ConceptsAdministrator Checklist for SQL Reporting Services
Copy Reports to Reporting Services Wizard