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



  • Open Reporting Services Configuration Manager
  • Connect to your RS server
  • Select 'Encryption Keys' from the left pane
  • If you do have a backup:
    • press the 'Restore' button instead of the 'Delete' button.
    • else: Press the 'Delete' button to get rid of your encrypted content
  1. After doing this, you will need to re-set the connection strings and stored credentials on your reports.
  2. Also, be sure to make a backup of the encryption key afterwards.