menu
  • Register

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

0 votes
1.8k 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?

7.5k points

Please log in or register to answer this question.

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.

38.6k points

Related questions

0 votes
1 answer 44 views
44 views
The report server was unable to validate the integrity of encrypted data in the database .
Problem: I am unable to resolve the issue. Does anyone have any clue about it: The report server was unable to validate the integrity of encrypted data in the database
asked Mar 15 Wafa Abu Yousef 6.1k points
0 votes
1 answer 15 views
15 views
Unable to connect to the report server.
Problem: Is there any way around this: Unable to connect to the report server?
asked May 22 Hridoy 19.2k points
0 votes
1 answer 7 views
7 views
Credentials stored securely in the report server
Problem: Credentials stored securely in the report server
asked Jul 1 nila 117k points
0 votes
1 answer 8 views
8 views
Ssrs credentials stored securely in the report server
Problem: Ssrs credentials stored securely in the report server
asked Jun 26 Shifa 18.2k points
0 votes
1 answer 4 views
4 views
The report server cannot process the report or shared dataset
Problem: Is there any way around this : The report server cannot process the report or shared dataset?
asked Jun 21 Mezbah 125k points
0 votes
1 answer 3 views
3 views
Sql server 2016 express with advanced services
Problem: Sql server 2016 express with advanced services?
asked Jul 6 Mezbah 125k points
0 votes
1 answer 2 views
2 views
Sql server 2016 express with advanced services download
Problem: Is there anyone who knows the answer :Sql server 2016 express with advanced services download?
asked Jun 25 Mezbah 125k points
0 votes
1 answer 22 views
22 views
Sql server move table to different schema
Problem: I am getting this .. can you help me to solve it? Sql server move table to different schema
asked May 5 Ifra 43.4k points
0 votes
1 answer 2 views
2 views
Report builder was unable to paste successfully.
Problem: Report builder was unable to paste successfully.
asked Jul 2 Priscilla Gurpreet 71k points
0 votes
1 answer 22 views
22 views
The definition of the report is invalid
Problem: How can I resolve the below error message that I receive when I try to deploy my report to our our Reporting Server using BIDS? Error: The definition of the report '/OrderAnalysis' is invalid
asked Mar 21 ummesalma 29.1k points
Dark theme