Friday, January 15, 2010
Report server : Encryption Keys Error
Ever got the error when viewing any report in MS CRM:
System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content.
Here's the solution to it: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. After doing this, you will need to re-set the connection strings and stored credentials on your reports.
PS: If you do have a backup, press the 'Restore' button instead of the 'Delete' button.
Posted by Shubhi at 6:08 AM