While creating a New Organization in CRM (Microsoft Dynamcis Deployment Manager), you may get this error:
Error Message :
Setup failed to validate specified Reporting Services Report Server http://ws08-64b/reportserver. Error: Error occured while finding an item on the report server.
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.
Resolution:
Delete the encrypted content.
Start >> Programs >> Microsoft Sql Server 2008 >> Configuration Tools >> Reporting Services Configuration Manager, this will open the Reporting Services Configuration Manager window.
Provide the server name and the reporting services instance name and click connect.
Select the Encryption Keys Tab on the left panel and click the Delete button, circled in the above picture.
Click Yes and once result is success, click exist.
For more details on deleting and re-creating encryption keys, please go through
http://msdn.microsoft.com/en-us/library/ms156010.aspx
