Thursday, June 4, 2026
type here...
CM InfrastructureReporting

After Upgrade SQL 2016 Report service error failed to load expression host assembly

By Haresh Hirani
0
1344

I will be share experience that once we completed upgrade Successful and by hearing sound my service is not working. I will be sharing experience that SQL server was upgrade 2014 SP2 To 2016 and Upgrade completed once report to office found that SQL report service stop responding.

Issue reported:

While access URL getting error failed to load expression host assembly

Error; 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. (rsErrorLoadingExprHostAssembly)


While seeing cm console we have seen without report url 


Solutions:

This error report normally after upgrade below are the key possibility

Point 1: Connection got broken between cm SERVER to report server

Point 2: If any access has been revoked from existing service

In my case I found that remove report service and reconfigure report service work fine.

Happy learnings!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr

Author

  • Hi, I’m Haresh Hirani the mind behind Hiraniconfigmgr.com. I’m a seasoned IT professional with deep expertise in Microsoft technologies, especially in Configuration Manager (ConfigMgr/SCCM). Over the years, I’ve expanded my skill set to cover a broader range of modern device management platforms like Microsoft Intune, Jamf Pro, ManageEngine Endpoint Central, and VMware AirWatch (Workspace ONE UEM), I use this blog to document real-world, tested, working fixes and walkthroughs from my daily technical experiences. The 💡idea is simple: if it helped me, it might help someone like you. My goal is to create a living repository of practical IT solutions for the community. If you find something useful, or if you want to collaborate, feel free to connect with me on LinkedIn or drop a message through the Contact page. Happy to help.

Previous article
ERROR SQL server Name Hostname in sys.servers does not match with the SQL server name
Next article
Mpcontorl.log error Call to HttpSendRequestSync failed for port 80 with status code 500

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Search

Latest posts

I’m the person behind this webpage. Thank you for visiting the website and about me page! My website is all about Microsoft technologies. More about ConfigMgr and all other technologies which are interesting for me. However, larger percentage of my posts are related to SCCM. Normally, like to post the interesting issues which I came across in my day to day tech life. you will find only solutions which comes on my day to day life.

Hot Category

Popular Post

© COPYRIGHT Hiraniconfigmgr.com

Developed By : Deepcoder