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:
- Change the account back to the original
- Run rskeymgmt -e to save the encryption key
- Change the account to the new one
- 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:
I, of course, a newcomer to this blog, but the author does not agree
Post a Comment