Use the Copy Reports to Reporting Services Wizard in Configuration Manager 2007 to copy the standard Configuration Manager reports to SQL Reporting Services.

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

This wizard contains the elements described in the following table.

Name Description

Data Source Settings page

  • Server name: Enter the name of the Configuration Manager 2007 database server to be used as the data source for SQL Reporting Services. To specify a database instance, use the format <Server Name>\<Instance Name>.

  • Database name: Enter the name of the Configuration Manager 2007 database to be used as the data source for SQL Reporting Services.

  • Test: Click to test the connection to the Configuration Manager 2007 database.

    Note
    If the connection test fails, a red warning symbol appears. Move the cursor over this symbol to read details of the failure. Correct the failure, and then click Test again.

Data Source Authentication page

  • Credentials supplied by the user running the report: This option is not currently supported by SQL Reporting Services in Configuration Manager 2007 R2.

  • Display the following text to prompt the user for a username and password: This option is not currently supported by SQL Reporting Services in Configuration Manager 2007 R2.

  • Credentials stored securely in the report server: Select this option if you want to store an encrypted user name and password for users to use to access reports on the report server. Use this option when you must run reports unattended—for example, initiate a report by a subscription.

  • User name: If the option Credentials stored securely in the report server is selected, enter the user name that users must use to access reports.

  • Password: If the option Credentials stored securely in the report server is selected, enter the password that users must use to access reports.

  • Use as Windows credentials when connecting to the data source: Select this check box if the specified credentials are Windows authentication credentials. Do not select this check box if you are using database authentication (for example, SQL Server authentication).

  • Impersonate the authenticated user after a connection has been made to the data source: If the option Credentials stored securely in the report server is selected, this option can be used to delegate credentials if the data source supports it. For more information about this option, see Microsoft SQL Server Books Online.

  • Windows integrated security: If selected, the credentials of the logged-on user are used to access the data source.

  • Credentials are not required: If selected, you do not have to enter credentials to connect to the data source.

Select Reports page

Specifies the reports you want to copy to the reporting services point.

  • Import existing reports – Specifies that you want to import existing Configuration Manager 2007 reports into SQL Reporting Services.

  • Import Report Definition Language files from a Microsoft signed cabinet file – Specifies that you want to import a Microsoft-signed cabinet file containing reports into SQL Reporting Services.

  • Overwrite existing reports - Overwrites any reports that already exist on the Reporting Services point.

Security page

Specifies the users and associated permissions that will be applied to the copied reports. For more information about the options on this page, see Reporting Services Properties: Security Tab.

Summary

Displays a summary of the actions that the wizard will take.

Confirmation

Confirms that the Configuration Manager reports were successfully copied to the Reporting Services point. When the wizard fails to copy reports, this page displays an error.

See Also