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

Gulshan Yashveer Beejan Microsoft Products

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! : )

Gulshan Yashveer Beejan

Gulshan holds a BSc(Hons) Computer Science with Distributed systems from the City University of London. He is currently working at DSOGroup(Mauritius) as a Linux Administrator on SaaS Solutions. More about Gulshan

Leave a Reply

Your email address will not be published. Required fields are marked *