The report server was unable to validate the integrity of encrypted data

user_8414782 0
Viewed 51162

The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) .

Could not restore the encryption key, so I deleted the keys and tried to regenerate with rskeymngt with no luck. Getting

'The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData)'

I get that error when accessing http://localhost/ReportServer and when running rskeymgmt -s.

Not sure what next step to take. I have reports that users need to access.

reporting-services sql-server-2016 encryption sql-server
5 Answers

I went into SSRS Configuration Manager > Encryption Keys > click Delete.

When I did that I got the error:

Failed to delete the encryption content in the report server database. Please execute the "DeleteEncryptedContent" stored procedure on the database manually.

To fix it I opened SQL Server Mgmt Studio > expand Databases > right click Report Server > new query and execute:

exec DeleteEncryptedContent

Start > Run > services.msc > Restart the "SQL Server Reporting Service" and its working.

user_4954550

Just go to the reporting service manager and delete the delete encrypted content or change content now try to connect once more it will be work.

enter image description here

user_139930030

You just need to change database again if you already created then your problem will be solved.

enter image description here

user_58823800

One reason for this could be that the encryption key did not restore correctly. I migrated a report database from one server to another. I restored the encryption key and all seemed well at first but the error the questioner posted started appearing shortly thereafter. Another site had posted a query to look at the keys in the report database (with further instructions of how to delete) and I noticed when I executed it that the SymmetricKey field for my server was NULL. I restored the encryption key again using the Report Server Configuration Manager and noticed that the SymmetricKeys was now populated. I was then able to browse to the report server.

user_17395060
Related