Deploying Reports Via Reporting Services Error

Question

When deploying Reporting Services Reports, I get the following error:

EXCEPTIONMESSAGE: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.

Answer 1

Open up Reporting Services Configuration Manager Encryption Keys Delete Encrypted Content

Answer 2

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:

3. You will need to reset all connection strings and db credentials for all your data sources.

And deleting the keys will not delete any data on the server. You reports will be fine, however your connection settings (data sources) will be gone. You will have to re create the connection for the reports.

You have to delete the encryption key because something is wrong with the encryption. Some setting must have changed. If you do not have a backup key, you have no other choice. Delete, create a new one, and create new connection strings.

Not a big problem.