Reinstall MBAM Reports server

John Biggston 71 Reputation points
2021-10-06T20:55:27.92+00:00

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 Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,807 questions
Windows 10 Security
Windows 10 Security
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
2,759 questions
Windows Server Security
Windows Server Security
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
1,729 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-10-07T08:45:43.66+00:00

    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.

    0 comments
  2. John Biggston 71 Reputation points
    2021-10-07T12:21:59.363+00:00

    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.

    0 comments
  3. Limitless Technology 39,371 Reputation points
    2021-10-08T07:40:04.83+00:00

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

    0 comments