Wednesday 25 May 2011

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database.

I got the following error when trying to use SQL Server Reporting Services manager:

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
Bad Data. (Exception from HRESULT: 0x80090005)

Solution:

You will need to reset your encryption keys. To do that:
  1. Open Reporting Services Configuration Manager and select 'Encryption keys' tab

  2. Click 'Delete' in 'Delete Encrypted Keys' section:
    SQL Server Reporting Services Configratuin Manager
  3. You will need to reset all connection strings and db credentials for all your data sources

3 comments:

WN2007 said...

Hi Filip,

Your instruction to execute "Delete Encrypted Content" in RSCM helped me in this error "The report server cannot decrypt the symmetric key...".
Thank you.

Waldek

lokesh said...

Thanks dude.. It's perfect..

Alex Oldman said...

This worked for me. I was using SQL 2008 R2. I backed up ReportServerDB and ReportServerTempDB just in case.