Failed to load expression host assembly. Details: Could not load file or assembly ‘SrsResources

Failed to load expression host assembly. Details: Could not load file or assembly ‘SrsResources

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”

image

And in Details:

image

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.

image

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.

image

Now locate the file rssrvpolicy.config. Default location will be C:Program FilesMicrosoft SQL ServerMSRS12.MSSQLSERVERReporting ServicesReportServer for your new SQL 2014 Reporting server.

image

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.

Table of Contents

Share this post
Search blog posts
Authors
Modern Workplace consultant and a Microsoft MVP in Enterprise Mobility.
Modern Workplace consultant and a Microsoft MVP in Windows and Devices for IT.

Infrastructure architect with focus on Windows Client management & security.

Cloud & security specialist with focus on Microsoft backend products and cloud technologies.

Infrastructure architect with focus on design, implementation, migration and consolidation.

Infrastructure consultant with focus on cloud solutions in Office365 and Azure.

follow us in feedly
Categories

Follow on SoMe