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
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
So what to do when you try to reinstall?
Rename one of these configuration files back to RSReportServer.config and web.config. Restart ReportServer Windows Service and IIS.
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
I constantly forget things. I hope this helps somebody not to scratch its head for a day and try different things.