I don’t often re-blog other postings, but this particular issue had me puzzled and it is worth giving this exposure. After the upgrade from SQL Server 2008 R2 to SQL 2012, if you check any of the CM SSRS reports, you’ll see the following error.
Failed to load expressions host assembly. Details: Could not load file or assembly ‘SrsResources. Culture=Neutral’ or one of its dependencies. The system cannot find the file specified.
After much research, and trial and error, I located this blog. Reposting relevant content here, below the link.
Issue
After the upgrade we noticed that Reports are not longer available. Opening a random report resulted in an error:
Failed to load expressions host assembly. Details: Could not load file or assembly ‘SrsResources. Culture=Neutral’ or one of its dependencies. The system cannot find the file specified.
Root Cause
As SQL Reporting Reporting Services is a component of SQL Server setup and thus Reporting Services will be upgraded as well. By default, the installation directory of SQL Server 2008 R2 Reporting Services, which may very to your custom parameters, is the following:
C:\Program Files\Microsoft SQL Server\MSRS10.50.MSSQLSERVER
Due to the upgrade from SQL Server 2008 R2 to SQL Server 2012 the default installation directory has changed to:
C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER
So the configuration defined in rssrvpolicy.config does not match the new situation. The SRSResources assembly url in rsssrvpolicy.config is still pointing to the installation path of SQL Server 2008 R2 instead of SQL Server 2012.
Solution
This issue can be solved by performing the following steps:
- Change the SRSResources assembly url in rssrvpolicy.config which is located in the new SSRS installation folder .\MSRS11.MSSQLSERVER\Reporting Services\Report Server\Bin
to
- Copy srsresources.dll from the old SSRS installation folder .\MSRS10.50.MSSQLSERVER\Reporting Services\Report Server\Bin to the new SSRS installation folder .\MSRS11.MSSQLSERVER\Reporting Services\Report Server\Bin.
- That is it!
Preferred Solution
Although we fixed this issue in a production environment and were able to reproduce it in a lab environment I am not sure the above steps are a recommended approach or are even supported by Microsoft. I guess a rhetoric question .
To be sure you are taking a ‘supported’ route the best way is to remove the Reporting Service Point (RSP) role and add it back again. How to install RSP is described in this TechNet wiki.
Pingback: Friday Five - September 27, 2013 - The Microsoft MVP Award Program Blog - Site Home - MSDN Blogs
Pingback: Upgrade 2008R2 to 2012R on Configuration Manager Site Systems – Part II – Upgrade Problems | Live Space Koenraad Rens
Thank you very much for the re-post, this just saved me after an upgrade from SQL 2012 to SQL 2016.