Unable to Decrypt Symmetric key when accessing IT Analytics Reports

Article:TECH200102  |  Created: 2012-11-26  |  Updated: 2013-02-06  |  Article URL http://www.symantec.com/docs/TECH200102
Article Type
Technical Solution


Issue



Cannot Decrypt Symmetric key error when attempting to access IT Analytics Reports.


Error



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.


Environment



Microsoft SQL 2005
Microsoft SQL 2008
IT Analytics 7.x


Cause



Corrupted symmetric key.


Solution



Restore from a backed up copy of the symmetric key to allow access to the database. If the symmetric key backup is not available, recreate the IT Analytics Analysis database, as described here:

Configuring IT Analytics Solution
http://www.symantec.com/docs/HOWTO48318




Article URL http://www.symantec.com/docs/TECH200102


Terms of use for this information are found in Legal Notices