CODEWITHSUNDEEP
sql-serverencryptionreporting-servicessql-server-2016
sqllearner
sqllearner

Reputation: 377

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

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.

Upvotes: 19

Views: 83257

Answers (5)

Jeremy Thompson
Jeremy Thompson

Reputation: 65702

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.

Upvotes: 35

Robb Vandaveer
Robb Vandaveer

Reputation: 1511

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.

Upvotes: 1

user13993003
user13993003

Reputation: 31

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

Upvotes: 3

Rohit Dodiya
Rohit Dodiya

Reputation: 271

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

enter image description here

Upvotes: 1

sqllearner
sqllearner

Reputation: 377

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

Upvotes: 4

Related Questions