{"id":883,"date":"2013-04-15T17:00:44","date_gmt":"2013-04-15T16:00:44","guid":{"rendered":"http:\/\/www.darrencoupland.com\/blog\/?p=883"},"modified":"2013-04-15T17:06:27","modified_gmt":"2013-04-15T16:06:27","slug":"reporting-services-ssrs-report-errors-after-performing-a-sharepoint-2010-site-collection-restore","status":"publish","type":"post","link":"https:\/\/www.darrencoupland.com\/blog\/2013\/04\/reporting-services-ssrs-report-errors-after-performing-a-sharepoint-2010-site-collection-restore\/","title":{"rendered":"Reporting Services (SSRS) Report Errors after performing a Sharepoint 2010 Site Collection Restore"},"content":{"rendered":"<p><strong>Issue:<\/strong><\/p>\n<p>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:<\/p>\n<p style=\"padding-left: 60px\"><span style=\"color: #000080\"><strong><em>The SharePoint site with the id {GUID} could not be found. (rsSPSiteNotFound)<\/em><\/strong><\/span><\/p>\n<p><strong style=\"line-height: 1.714285714;font-size: 1rem\">Resolution:<\/strong><\/p>\n<p>Resolving the issue is a relatively simple process:<\/p>\n<ol>\n<li>Browse to the Data Connections on the your Sharepoint Site<\/li>\n<li>For each Data Source that is used in any SSRS SP2010 Integrated Report perform the following:<br \/>\n2.1 Click on the Data Source in the &#8216;Name&#8217; column and select &#8216;Edit Data Source Definition&#8217;<br \/>\n2.2 Click on &#8216;Test Connection&#8217;<br \/>\n2.3 Click on &#8216;OK&#8217; if the connection test is successful<\/li>\n<li>Re-run the SSRS Report and it should work okay now<\/li>\n<\/ol>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[35],"tags":[61],"class_list":["post-883","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2010","tag-sharepoint-2010"],"_links":{"self":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/883","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/comments?post=883"}],"version-history":[{"count":3,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/883\/revisions"}],"predecessor-version":[{"id":894,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/posts\/883\/revisions\/894"}],"wp:attachment":[{"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/media?parent=883"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/categories?post=883"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.darrencoupland.com\/blog\/wp-json\/wp\/v2\/tags?post=883"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}