Reinstall MBAM Reports server

Question

Hi,
I have MBAM installed in standalone mode with SQL hosted on a remote server cluster. Everything was working but now, for some reason, when I try to run the reports I'm getting the 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. (rsReportServerDisabled) Get Online Help
Keyset does not exist (Exception from HRESULT: 0x80090016)"

I've gone in to the SRSS config and am unable to locate the encryption key backup file, so I'm looking at re-creating the reports server role to get them working again. Is it as simple as just removing the role, leaving the databases intact and then reinstalling the role and pointing it to the same DB's on the same server with the same credentials or do I need to delete the encrypted content through SRSS and then reinstall?

Thanks

Answer 1

Hi @John Biggston ,

"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. (rsReportServerDisabled) Get Online Help. Keyset does not exist (Exception from HRESULT: 0x80090016)"

You need to consider deleting the Encryption keys. For more information,please refer to: Delete and Recreate Encryption Keys (Report Server Configuration Manager).
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

The problem with that is that if I delete the keys, I have to also delete all encrypted content and re-create the database connection. That's why I'm thinking of just removing and re-adding the report services role so that MBAM does all of that automatically.

Answer 3

Hello,

Thank you for your question.

It can fixed using steps as below.

1. Click Start -> All Programs -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration Manager .
2. Connect to your RS server.
3. Select Encryption Keys from the left pane.
4. Press the Delete button to get rid of your encrypted content, or press the Restore button if you have a backup.

---

--If the reply is helpful, please Upvote and Accept as answer--