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
Posted by Filip Czaja at 23:50
Labels:

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

15 March 2012 at 08:17
lokesh said...

Thanks dude.. It's perfect..

19 April 2013 at 01:15
Alex Oldman said...

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

15 July 2013 at 07:16

Post a Comment

Subscribe to: Post Comments (Atom)