Menu
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.
722
You can use rskeymgmt to back up, delete, or restore the keys. If the keys cannot be restored, this tool provides a way to delete encrypted content that can no longer be used. The rskeymgmt utility is used to manage the key set that is defined during Setup or during initialization.
A scale-out deployment is used in the following scenarios: As a prerequisite for load balancing multiple report servers in a server cluster. Before you can load balance multiple report servers, you must first configure them to share the same report server database.
Reference : SSRS Troubleshooting: The report server was unable to validate the integrity of encrypted data in the database. Reporting Services Web Portal Error: the report server was unable to validate the integrity of encrypted data in the database Hope it can help you.
System administrators: The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, reimport encrypted content, or delete all encrypted content and generate a new encryption key.
SSRS Troubleshooting: The report server was unable to validate the integrity of encrypted data in the database. - TechNet Articles - United States (English) - TechNet Wiki SSRS Troubleshooting: The report server was unable to validate the integrity of encrypted data in the database.
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.
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 service and its working.
150
Restarted the services and now everything is working.
So it looks like in order to generate a new key I need to update the Report Server Service account. After that restart the sql server reporting services.
I no longer have the encryption error, but now I am asked for a log in to the data source after clicking on the report. I enter the creds again but get 'The ConnectionString property has not been initialized.'
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
