Operations Manager 2012 R2 Report Server Install: The specified SQL Server instance is not valid

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:

  1. Open SQL Server Reporting Services Configuration Manager on the server that you are installing the Report Server role on to.
  2. Go to the Encryption Keys tab
  3. Under the “Delete Encrypted Content” section, click the “Delete” button
  4. The install wizard should now continue

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.