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

sql-server encryption reporting-services sql-server-2016
sqllearner picture sqllearner · Sep 13, 2017 · Viewed 31k times · Source

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.

Answer

Jeremy Thompson picture Jeremy Thompson · Nov 19, 2018

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.

Related questions

How to encrypt all existing stored procedures of a database

Is there any possibility to encrypt all existing stored procedures of a SQL Server 2008 database AFTER they have been created via an SQLCMD script? The reason I want to do this is the following: I'd like to develop the stored …

Read More
Operand type clash: varchar is incompatible with varchar(50) trying to insert in encrypted database

I am getting a SqlException: Operand type clash: varchar is incompatible with varchar(50) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'PB') …

Read More
Preferred Method of Storing Passwords In Database

What is your preferred method/datatype for storing passwords in a database (preferably SQL Server 2005). The way I have been doing it in several of our applications is to first use the .NET encryption libraries and then store them in …

Read More