Install SCOM Reporting role again on the same SSRS server aka FileNotFoundException: Could not load file or assembly ‘Microsoft.EnterpriseManagement.Reporting.Security’

SCOM reporting and me!? We are lately on the war path. I decided yesterday to remove SCOM 1711 technical preview and install SCOM 1801 final release. When I started to install reporting role I get this error screen

image

I checked everything and everything was fine. Next steps were logs. Error in logs was: ERROR: Exception caught instantiating Windows report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. —> System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.EnterpriseManagement.Reporting.Security’ or one of its dependencies. The system cannot find the file specified.

What is the problem? Problem is that SCOM modifies the configuration files of the SQL Reporting Service with its own configuration. It makes copies of original configuration files as RSReportServer.config.0, RSReportServer.config.1 and web.config.0

image

So what to do when you try to reinstall?

Method 1

Rename one of these configuration files back to RSReportServer.config and web.config.  Restart ReportServer Windows Service and IIS.

Method 2

Run ResetSRS.exe tool you can find on SCOM installation media under Support Tools folder . It will reset configuration of SRS. After you run it restart SSRS services. Tool is used in command prompt in this manner c:\resetSRS.exe <SQLINSTANCENAME>

image

image

I constantly forget  things. I hope this helps somebody not to scratch its head for a day and try different things.

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s