• Register
0 votes
954 views

Problem :

My report server was not able to verify the integrity of the encrypted data in the database.

So getting following error rsCannotValidateEncryptedData

Also it could not restore the original encryption key, so I just tried deleting the keys and then tried to regenerate them with the help of rskeymngt -s but no luck. I am facing following error

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

I am unable to resolve the issue. Does anyone have any clue about it?

6 5 3
7,540 points

1 Answer

0 votes

Solution :

I also had faced the same issue. So to fix the issue I followed the below steps:

I just went to following path SSRS Configuration Manager > Encryption Keys > click Delete.

But when I did that I got following error message:

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

After getting this error I went to following path SQL Server Mgmt Studio > Report Server > new query:

exec DeleteEncryptedContent

And executed the above command. After that I simply restarted the service.And it started working for me.

If you follow the above mentioned procedure carefully then your issue will also get resolved.

9 7 4
38,600 points

Related questions

1 vote
1 answer 27 views
27 views
Problem : I am very new to report processing. Currently I am working on integrating my report to the browser but I often face following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source ' ... report error but still unable to fix it. So now I am looking for expert advice on fixing above reporting error.
asked Apr 28 stewart 4k points
0 votes
1 answer 43 views
43 views
Problem: I am new, I need help, can anyone help me by filling in the blanks?? ​The acronym ____________ refers to software that manages data stored in a database.​​ A) ​ERP B) SQL​ C) ​OLAP D) ​DBMS
asked Feb 19 maddi86 5.4k points
0 votes
2 answers 177 views
177 views
Problem : I want to access my hosting server’s database through SQL Server Management Studio, everything is fine but when I use the following command use myDatabase it gives me following error: The server principal "****" is not able to access the database "****" under the current security context. Can anyone give me solution on my problem?
asked Nov 21, 2019 peterlaw 6.9k points
0 votes
1 answer 10 views
0 votes
1 answer 11 views