Friday, October 01, 2004

Reporting Services Symetric Key Error

I had a problem with SQL Reporting Services today, and came across the following post on SQL Junkies that resolved it.

The error was: "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 and then restart the service. "

As it turned out, my user ID had changed, and I no longer had permission to run the report. The text of the SQLJunkies is as follows:

Did you change the account that the reporting services windows service runsunder? Or did that accounts password get reset?If you changed the account, you can fix this problem by:

  1. Change the account back to the original
  2. Run rskeymgmt -e to save the encryption key
  3. Change the account to the new one
  4. Run rskeymgmt -a to resave the key for the new user.

If the password was reset and you have not previously made a backup of the encryption key, there is no way to recover the data. You will need to runrskeymgmt -d to delete the encrypted content. Besure to restart IIS afterdoing that.


1 comment:

generic cialis said...

I, of course, a newcomer to this blog, but the author does not agree