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

Issue：

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

Resolution：

Do you have a backup of your encryption key?  If not, follow these steps:

 

1  Open 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

5  You will need to re-set the connection strings and stored credentials on your reports.

 

PS:  You'd better make a backup of the encryption key afterwards.

 

If you do have a backup, press the 'Restore' button instead of the 'Delete' button.