SharePoint Integrated SSRS Reports Fail To Run After An Upgrade To Claims Authentication

Following an upgrade to SharePoint 2013 and claims based authentication, SSRS reports fail to load and you receive the error “Microsoft.SharePoint.SPException: User cannot be found”.

SSRS Error 1 SSRS Error 2

Unfortunately, many blog posts and forum entries say that you have to reload all the reports and data sources and I’ve been unable to find any alternative.  What I describe here is my attempt to make the process of reloading reports and data sources as painless as possible.

Within SharePoint 2013, navigate to the SSRS report library.  Take a note of the configuration of each data source as you will need it later.  Next, take a note of the data source used by each report.  Next, from the ribbon, choose to “Open with Explorer”.

SSRS Error 3

Within the Explorer view highlight all the report and data source folders.  Copy and paste the contents to another location, e.g. local hard drive, or network drive.

SSRS Error 5

Now select all the folders on the local drive and copy and paste them back to SharePoint 2013, overwriting the existing files.  I found that following this process the data sources became disabled, so for each data source edit the data source definition, re-enter any credentials and enable the data source.

SSRS Error 7 SSRS Error 8

Once the data sources have been configured, reconnect each report to the appropriate data source.

If anyone knows of a better way, which doesn’t involve redeploying all the reports and data sources, please let me know!

SSRS Error 9

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s