Issue in accessing reporting service web service URL

Question

Hi All,

I am seeing below error message when I try to access the reporting service web service URL, also the backup option at the encryption keys page is already disabled and we don't know who backed up the keys to perform the restore. Could some one please advise the safest way to fix the issue without loosing any data.

Reporting Services Error
The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) Get Online Help
Keyset does not exist (Exception from HRESULT: 0x80090016)

Thanks in Advance!

Answer 1

Hi @Kranthi DBA ,
To solve this error "The report server was unable to validate the integrity of encrypted data in the database", you have to do one of the following solutions:

1. Delete Encrypted Content in SSRS Configuration Manager.
2. Reconfigure the current report server database.

1)Delete Encrypted Content in SSRS Configuration Manager.

• Open Reporting Service Configuration Manager.
• Connect to your report server instance.
• Click on "Encryption Keys", then click on "Delete" to delete all encrypted data in the report server database.
  If you can't delete the "Encryption Keys", and got this error "Failed to delete the encryption content in the report server database. Please execute the "DeleteEncryptedContent" stored procedure on the database manually.". so you should do the following:
  a. Open SQL Server Management Studio >
  b. Click on the new query and run the below SQL query: use Report_Server_Name
  exec DeleteEncryptedContent
  c. Open the Services, and restart SQL Server Reporting Services.

2) Reconfigure the current report server database.

• Open Reporting Service Configuration Manager.
• Connect to your report server instance.
• Click on "Database" > click on Change database.

Best Regard,
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.