Search code examples
sql-serversql-server-2008encryptionreporting-servicesssrs-2008

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

I am getting the following error when trying to deploy my SSRS reports on our SQL 2008 R2 Server "The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database...". Most of the solutions on the Web suggest to delete the encryption keys, then reconfigure the datasources. I am still a beginner in SSRS, Is there another solution to fix this issue, Thanks

Solution

  • After checking this link Microsoft support link, it seems that this is a know issue in SSRS reports. And it seems the only way to fix it is to delete the Encryption keys.

    1. Open Reporting Services Configuration Tool ( Programs->Microsoft SQL Server 2008 R2 -> Configuration tools -> Reporting Services Configuration Manager)
    2. Go to Encryption Keys
    3. Click Delete.

    This solved my problem