locked
Recovering the symmetric key from the Keys table RRS feed

  • Question

  • We had a server give out on us completely. All that is left is a back up of the SSRS database. We have been able to get a new SSRS environment working but the symmetric key doesn't seem to work.  Reports will run if we delete all sensitive data through the Config manager and reenter the connection strings into the datasource but if we can get the symmetric key saved in the ReportingServices database to work correctly it will save us a ton of effort.

    Can we make use of the symmetric key saved in the ReportServer.dbo.Keys table?

    Wednesday, July 29, 2015 11:14 PM

Answers

  • If you don't have a backup of your encryption keys you will not be able to recover/restore the key, that is why its always a good practice to backup your encryption keys as well as your reportserver db. 


    Thursday, July 30, 2015 2:35 AM

All replies

  • If you don't have a backup of your encryption keys you will not be able to recover/restore the key, that is why its always a good practice to backup your encryption keys as well as your reportserver db. 


    Thursday, July 30, 2015 2:35 AM
  • Thanks. That is what I was afraid of, but a guy can hope...
    Thursday, July 30, 2015 1:53 PM