If you choose to do an in place upgrade of SQL 2012 to SQL 2014 on your SCCM server, you might see this error when trying to run a report:
Failed to load expression host assembly. Details: Could not load file or assembly ‘SrsResources, Culture=neutral’ or one of its dependencies. The system cannot find the file specified”
And in Details:
The best way around this error is to remove the Reporting services point and add it again after it has been removed.
But if this is in a lab, here is a quick (and dirty) workaround:
Open the old Report Server BIN folder and copy srsresources.dll and the SCCMErrorResource (folder structure) default location will be C:Program FilesMicrosoft SQL ServerMSRS11.MSSQLSERVERReporting ServicesReportServerbin when upgrading from SQL 2012.
And paste the file and folders to the new Report Server BIN folder as shown here:
Default location will be C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVERReporting ServicesReportServerbin when upgrading to SQL 2014.
Now locate the file rssrvpolicy.config. Default location will be C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVERReporting ServicesReportServer for your new SQL 2014 Reporting server.
Edit the file and change the URL for srsresources.dll to the new location (just search for srsresources.dll to find the place to change)
Change from:
<IMembershipCondition class=”UrlMembershipCondition” version=”1″ Url=”C:Program FilesMicrosoft SQL ServerMSRS11.MSSQLSERVERReporting ServicesReportServerbinsrsresources.dll” />
Change it to:
<IMembershipCondition class=”UrlMembershipCondition” version=”1″ Url=”C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVERReporting ServicesReportServerbinsrsresources.dll” />
Save it and after a short wait period, try running a report again to test if its working as expected.
