Migrate reports from SCCM 2007 to SCCM 2012 SP1

The built-in migration wizard in ConfigMgr 2012 can migrate most objects but not reports. In ConfigMgr 2012 classical ASP reports (as we know them from earlier versions) are no longer supported.

Migrate the classical reports to SQL Reporting Services in SCCM 2007

Below is a walk thru of how you migrate your existing classical reports to SQL reporting Services in SCCM 2007. Notice that you will still be able to run all classical reports after the migration.

  1. On you SCCM 2007 site server install either SCCM 2007 R2 or SCCM 2007 R3, both will add SQL Reporting Services support for SCCM 2007.
  2. In the ConfigMgr. console, navigate to Site Database, Site Management, A01 (where A01 is the sitecode), Site Systems. Right click the Site system server that will become a Reporting Services Point and click New Roles. Select Reporting Services Point and finish the wizard using the default values.
  3. In the ConfigMgr. console, navigate to Site Database, Computer Management, Reporting, Reporting Services, and expand the node.
  4. Right-click SCCM1 (where SCCM1 is the name of your server), and then click Properties.
  5. On the Data Source Settings tab, specify SCCM1 as the database server and SMS_A01 as the database name (where SMS_A01 is the name of your SCCM 2007 database. Click Test.
  6. On the Data Source Authentication tab, select Windows integrated security.
  7. Click OK.

Copy reports to SQL Reporting Services

  1. Right-click SCCM1, and select Copy Reports to Reporting Services.
  2. On the Data Source Settings page, accept the default settings, and click Next.
  3. On the Data Source Authentication page, accept the default settings, and click Next.
  4. On the Select Reports page, accept the default settings, and click Next.
  5. On the Security page, accept the default settings, and click Next.
  6. On the Summary page, click Next.
  7. On the Progress page – once all of the reports have copied – click Next and then click Close.

Migrate the SCCM 2007 reports to SCCM 2012

You can’t use the built-in migration tools to migrate reports from SCCM 2007 to SCCM 2012. This leaves you with two choices; 1) Download each RDL file one by one from SCCM 2007 and upload them to SCCM 2012 or 2) Use one of the free community tools that can download multiple folders at the time. In my last project I used this tool – ReportSync – to assist me.

  1. Launch ReportSync
  2. In Source server type in the name of the SCCM 2007 Report server in form of http://CM01/ReportServer. Provide credentials and click Load
  3. In Destination server type in the name of the SCCM 2012 Report server in form of http://CM02/ReportServer. Provide credentials and click Load

    image

  4. Select the folders or individual reports you want to migrate.
  5. Select the Tools menu and click Map Datasources. Select the Destination data source, click Set and OK.

    image

  6. Click Sync
    image
  7. Once the process is finished click OK and your reports are now ready in SCCM 2012.
  8. Run the report and verify that it works. There is no guarantee the all SCCM 2007 reports work out of the box in SCCM 2012.
    image

     

By | 2013-02-09T09:42:03+00:00 February 9th, 2013|Configuration Manager (SCCM), General info|11 Comments

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

11 Comments

  1. rachael June 21, 2013 at 14:21 - Reply

    Hi, I get error when i try to load the report web services URL, somthing like “the request failed with http status 404”

    Con you help me please

  2. rachael June 21, 2013 at 14:22 - Reply

    Hi, I get error when i try to load the report web services URL, somthing like “the request failed with http status 404”

    Can you help me please

  3. Rick September 17, 2013 at 13:04 - Reply

    to avoid this error. Copy the url to reports in Reporting Services configuration tool and paste in reportsync

  4. Wyatt October 8, 2013 at 15:26 - Reply

    Hi!!

    It is possible to use this tool when the report server of SCCM 2012 is configured with SSL?
    I’m not sure because I get the error “Loading Failed. The underlying conection was closed. Could not established relationship for the SSL/TLS sure channel” configuring the destination SSRS webservice with HTTPS (https://FQDNServerName/Reportserver.

    Thanks & regards

    • Tristan May 9, 2014 at 15:33 - Reply

      When you have this problem, all you have to do is change the following line which can be found in the following file:

      MSRS11.MSSQLSERVERReporting ServicesReportServerrsreportserver.config

      Line:

      Change the vallue to 0 and there is no SSL needed and it wil connect using HTTP.
      At this moment there will be a vallue of 1, 2 or 3.

    • Tristan May 9, 2014 at 15:36 - Reply
  5. Hardeep September 9, 2015 at 13:04 - Reply

    Hi, I have SCCm 2012 R2 SP1 and when i tried to copy the reports it worked fine till the time of sync..when i try to run the reports.
    I get the following error

    “An error occurred during client rendering.
    An error has occurred during report processing.
    Cannot create a connection to data source ‘AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_’.
    You have specified integrated security or credentials in the connection string for the data source, but the data source is configured to use a different credential type. To use the values in the connection string, you must configure the unattended report processing account for the report server.”

    It also changed something on my 2007 and now the weblink doesent work and gives me the same error

    • Pratik Dave December 8, 2016 at 7:27 - Reply

      Too late but you have to enable edit from Map Datasources.

  6. Pratik Dave December 8, 2016 at 7:24 - Reply

    Your work is still useful…Thanks a lot Kent, Love your work.

Leave A Comment