Export (0) Print
Expand All
Expand Minimize

Copy Reports to Reporting Services Wizard

Updated: October 14, 2010

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

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

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

    noteNote
    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

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