Came across this error on the “SQL Server instance for reporting services” page, when trying to install the reporting server for Operations Manager: The specified SQL Server instance is not valid.
I was installing the report server on a separate server, which means i had SSRS installed on the server and pointed to the SCOM DW.
From some research this can be because of a few reasons. The fix that worked for me was deleting the encryption data. The steps below detail how to achieve this:
- Open SQL Server Reporting Services Configuration Manager on the server that you are installing the Report Server role on to.
- Go to the Encryption Keys tab
- Under the “Delete Encrypted Content” section, click the “Delete” button
- The install wizard should now continue