question

JohnBiggston-8696 avatar image
0 Votes"
JohnBiggston-8696 asked LimitlessTechnology-2700 answered

Reinstall MBAM Reports server

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

sql-server-reporting-serviceswindows-10-securitywindows-server-security
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @JohnBiggston-8696 ,

"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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JohnBiggston-8696 avatar image
0 Votes"
JohnBiggston-8696 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LimitlessTechnology-2700 avatar image
0 Votes"
LimitlessTechnology-2700 answered

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--

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.