cancel
Showing results for 
Search instead for 
Did you mean: 

The Report Server Cannot Decrypt the Symmetric Key...

Anon
Community Manager

The Report Server Cannot Decrypt the Symmetric Key...

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. (rsReportServerDisabled) Get Online Help


Keyset does not exist (Exception from HRESULT: 0x80090016)

Open Reporting Services Configuration Manager
Connect to your RS server
Select 'Encryption Keys' from the left pane
Press the 'Delete' button to get rid of your encrypted content (If you do have a backup, press the 'Restore' button instead of the 'Delete' button.)
After doing this, you will need to re-set the connection strings and stored credentials on your reports.
To do this successfully, I ran setupreports.bat again with all of the same answers except:
I did not overwrite Reports
I added a SQL Login during the script that seemed to reset the encryption
For future prevention, make a backup of the encryption key afterwards.
Tags (1)