Error: The report server cannot decrypt the symmetrical key used to access sensitive or encrypted data in a report server database.

Subscription warning: Error connecting to System.Web.Services.Protocols.SoapException: 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
Email It to Me Print this Page
Symptoms The error "The report server cannot decrypt the symmetrical key used to access sensitive or encrypted data in a report server database" appears when trying to access SQL SRS Advanced Reporting.
Cause This issue occurs when encryption keys used to access report server got corrupted and the server cannot decrypt the symmetrical key.
Resolution To resolve the issue you will need to restore the corrupted keys or remove them.

To do it, perform the following steps:
  1. Click Start -> All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration Manager .
  2. Connect to your RS server. 
  3. Select Encryption Keys from the left pane.
  4. Press the Delete button to get rid of your encrypted content, or press the Restore button if you have a backup.

 User-added image

After performing these steps, you will need to re-set the connection strings and stored credentials in the product report settings.

  1. Run Netwrix Auditor.
  2. In the left pane navigate to Managed Objects -> <your_Managed_object> -> <your_target_system> -> Reports.
  3. In the right pane switch to Report Settings tab.
  4. Specify settings (SQL instance, Report Server URLs and credentials) to connect to the SQL database and click Apply

Make a backup of the encryption keys after performing these steps.

Was this information helpful?