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


Weird error.. everything was working fine a few weeks back and now we’re stuck with this weird error from the reports server on the CRM Dynamics Windows 2008 Server.

Resolution:

Reboot did not work.. lol

Go to Reporting Services Configuration Manager -> Encryption Keys -> Delete

And… it works fine again! : )

Read More