Before you can manage reports in Configuration Manager 2012, 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 2008 Reporting Services.
SQL Server Reporting Services
Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. The Reporting Services point in Configuration Manager 2012 communicates with Reporting Services to copy Configuration Manager reports to a specified report folder, configure Report Services settings, and to configure Report Services security settings. Reporting Services connects to the Configuration Manager 2012 site database to retrieve data that is returned when you run reports. For more information about installing Reporting Services, see the section of the SQL Server 2008 Books Online (http://go.microsoft.com/fwlink/?LinkId=212032).
Reporting Services Point
Before you can manage reports in Configuration Manager 2012, 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.
To install the reporting services point on an existing site system server
-
In the Configuration Manager console, click Administration.
-
In the Administration workspace, expand Site Operations, and then click Servers and Site System Roles.
-
Click the server in which you want to install the reporting services point site role. When you click a server, a list of the site system roles that are already installed on the server are displayed in the details pane.
-
On the Home tab, in the Server group, click Add Site System Role. The Create Roles Wizard opens.
-
On the General page, specify the general settings.
-
On the System Role Selection page, select Reporting Services point from the list of available roles, and then click Next.
-
On the Reporting Services Point page, configure the following settings:
- Site database server name: Specify the name
of the server that hosts the Configuration Manager 2012
site database. Typically, the wizard will automatically retrieve
the server name.
- Database name: Specify the site database
name, and then click Verify to confirm that the wizard has access
to the site database.
- Folder name: Specify the folder name that
will be created and used to host the
Configuration Manager 2012 reports in on the Reporting
Services point site system server.
- Reporting Services server instance: Select
the SQL Server instance used by SQL Reporting Services.
.gif)
ImportantWhen no Reporting Services server instances are available, verify that SQL Reporting Services is installed and configured. - Credentials: Specify the credentials that
will be used when SQL Reporting Services on the Reporting Services
point site system server connects to the
Configuration Manager 2012 site database to retrieve the
data displayed in a report.
Use the following recommended configuration for reporting in Configuration Manager 2012:
- Select Credentials stored securely in the
report server. This option stores an encrypted user name and
password that is used to access reports on the report server. Click
Set to configure the user account and password, and then click
OK.
- Select Use as Windows credentials to connect
to the data source. This option classifies the credentials as
Windows authentication credentials.
- Do not select Impersonate the authenticated
user after connection has been made to the data source. This option
allows delegation of credentials if the data source supports it.
You should not select this option when running reports in the
Configuration Manager console. For more information about this
option, refer to your SQL Server documentation.
- Select Credentials stored securely in the
report server. This option stores an encrypted user name and
password that is used to access reports on the report server. Click
Set to configure the user account and password, and then click
OK.
- Site database server name: Specify the name
of the server that hosts the Configuration Manager 2012
site database. Typically, the wizard will automatically retrieve
the server name.
-
On the Reporting Services Point page, click Next.
-
On the Summary page, verify the settings and complete the wizard. After the wizard completes, the Configuration Manager 2012 reports are copied to the specified report folder and security is configured on the Reporting Services point computer.
To install the reporting services point on a new site system server
-
In the Configuration Manager console, click Administration.
-
In the Administration workspace, expand Site Operations and click Servers and Site System Roles.
On the Home tab, in the Create group, click Create Site System Server. The Create Server Wizard opens.
-
On the General page, specify the general settings.
-
On the System Role Selection page, select Reporting Services point from the list of available roles, and then click Next.
-
On the Reporting Services Point page, configure the following settings:
- Site database server name: Specify the name
of the server that hosts the Configuration Manager 2012
site database. Typically, the wizard will automatically retrieve
the server name.
- Database name: Specify the site database
name, and then click Verify to confirm that the wizard has access
to the site database.
- Folder name: Specify the folder name that
will be created and used to host the
Configuration Manager 2012 reports in on the Reporting
Services point site system server.
- Reporting Services server instance: Select
the SQL Server instance used by SQL Reporting Services.
ImportantWhen no Reporting Services server instances are available, verify that SQL Reporting Services is installed and configured. - Credentials: Specify the credentials that
will be used when SQL Reporting Services on the Reporting Services
point site system server connects to the
Configuration Manager 2012 site database to retrieve the
data displayed in a report.
Use the following recommended configuration for reporting in Configuration Manager 2012:
- Select Credentials stored securely in the
report server. This option stores an encrypted user name and
password that is used to access reports on the report server. Click
Set to configure the user account and password, and then click
OK.
- Select Use as Windows credentials to connect
to the data source. This option classifies the credentials as
Windows authentication credentials.
- Do not select Impersonate the authenticated
user after connection has been made to the data source. This option
allows delegation of credentials if the data source supports it.
You should not select this option when running reports in the
Configuration Manager console. For more information about this
option, refer to your SQL Server documentation.
- Select Credentials stored securely in the
report server. This option stores an encrypted user name and
password that is used to access reports on the report server. Click
Set to configure the user account and password, and then click
OK.
- Site database server name: Specify the name
of the server that hosts the Configuration Manager 2012
site database. Typically, the wizard will automatically retrieve
the server name.
-
On the Reporting Services Point page, click Next.
-
On the Summary page, verify the settings and complete the wizard. After the wizard completes, the Configuration Manager 2012 reports are copied to the specified report folder and security is configured on the Reporting Services point computer.