Reporting Services (SSRS) Report Errors after performing a Sharepoint 2010 Site Collection Restore

Issue:

After a restore of a Sharepoint 2010 Site Collection is performed you may receive the following error when attempting to run an SSRS report if you are running Reporting Services in Sharepoint Integrated Mode:

The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound)

Resolution:

Resolving the issue is a relatively simple process:

  1. Browse to the Data Connections on the your Sharepoint Site
  2. For each Data Source that is used in any SSRS SP2010 Integrated Report perform the following:
    2.1 Click on the Data Source in the ‘Name’ column and select ‘Edit Data Source Definition’
    2.2 Click on ‘Test Connection’
    2.3 Click on ‘OK’ if the connection test is successful
  3. Re-run the SSRS Report and it should work okay now

Leave a Reply

Your email address will not be published. Required fields are marked *