Problem description: you are trying to install SCOM 2012, and the SQL Server reporting service 2012 part failed.
–> Inside SCOM Setup installation, you got the error message below
eThe specified SQL Server instance is not valid. The possible causes of this problem include the following:
* SSRS has not been configured correctly
* Secure Socket Layer (SSL) is configured for the SQL Server Report Server.
* A proxy server is configured for the SQL Server Report Server.e
–> And if you open your report server http://myserver/reportserver, you got the error message below
“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)”
Step 1: Go on the SSRS log file to get more detail. By default is here: C:Program FilesMicrosoft SQL ServerMSRSXX.MSSQLSERVERReporting ServicesLogFiles
Step 2: Open the last ReportServerService…txt, and have a look to the last error at the end of the file.
In my case, I have got this error:
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Unable to load assembly Microsoft.EnterpriseManagement.Reporting.Security, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Le serveur de rapports a rencontré une erreur de configuration. —> 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.
Cause: This issue is due to SCOM that it changes the configuration files of the SQL Reporting Service.
Choice 1: Uninstall and reinstall SSRS
Choice 2 : When SCOM 2012 change the SQL Reporting Service 2012 configuration files, it takes the backup of the Reporting Service’s configuration files as: RSReportServer.config.0 and RSReportServer.config.1.
– So, go to C:Program FilesMicrosoft SQL ServerMSRSXX.MSSQLSERVERReporting ServicesReportServer.
– Then remove the file RSReportServer.config. And rename RSReportServer.config.0 to RSReportServer.config
More detail here: How to Install the Operations Manager Reporting Server
Michel Degremont | Xbox Live Music – DBA Team – SQL Server & PDW |