If you just updated your EdgeSight server and you get an error message like this when hitting the web console:
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. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help Bad Data. (Exception from HRESULT: 0x80090005)
the solution is very easy. Just go to your SQL Server and delete the existing keys by opening command prompt and typing:
rskeymgmt -d
then:
rskeymgmt -s
to recreate them. Restart the “SQL Server Reporting Services” windows service for good measure if you like and refresh your browser. EdgeSight should load up fine now. There is a good article here by MS that goes into more detail about the Reporting Services encryption keys here:
http://technet.microsoft.com/en-us/library/ms156010.aspx
