menu
  • Register

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

0 votes
1.3k 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

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.

●9 ●7 ●4
38,600 points

Related questions

1 vote
1 answer 38 views
38 views
An error has occurred during report processing rsprocessingaborted.
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, 2020 stewart 4k points
0 votes
1 answer 1 view
1 view
missing secure attribute in encrypted session ssl cookie
Problem: How to solve : missing secure attribute in encrypted session ssl cookie HELP! I need help understanding this : missing secure attribute in encrypted session ssl cookie Can someone please help fix this, I am new in java. Anyone have ideas on what I need to do to understand this? Thanks!
asked 2 hours ago Ali 6.2k points
0 votes
1 answer 69 views
69 views
The acronym ____________ refers to software that manages data stored in a database?
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, 2020 maddi86 5.4k points
0 votes
2 answers 234 views
234 views
the server principal is not able to access the database under the current security context.
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 34 views
34 views
the permissions granted to user are insufficient for performing this operation. (rsaccessdenied)
Problem : Facing permission issues need solution on it the permissions granted to user are insufficient for performing this operation. (rsaccessdenied)
asked Nov 12, 2019 peterlaw 6.9k points
0 votes
1 answer 44 views
44 views
When you identify the data elements in a new database, you typically subdivide data elements into?
Problem: I am new to SQL, I need help, can anyone help me? When you identify the data elements in a new database, you typically subdivide data elements into? a. The largest practical components. b. The smallest practical components. c. Components that can be easily parsed each time you use them.
asked Feb 17, 2020 maddi86 5.4k points
0 votes
1 answer 6 views
6 views
Copy tables from one database to another in SQL Server
Problem: I have a database named foo and a database named bar. I have a table in foo called tblFoobar that I want to move data (and all) to the database from the database bar of foo. What is the sql statement to do this?
asked 6 days ago sasha 13.2k points
0 votes
1 answer 41 views
41 views
How to connect sql server database in asp.net mvc 5?
I wonder to know how I may connect sql server database in asp.net mvc5 . Note that I’m not expert in this field.
asked Dec 7, 2020 Imtiaz268 340 points
0 votes
1 answer 24 views
24 views
How to copy table from one database to another in sql server?
I’m new in sql server. Can anyone help me to solve this problem?
asked Dec 7, 2020 TeamScript 13.5k points
0 votes
1 answer 13 views
13 views
How to create a database in SQL server 2008
asked Oct 26, 2020 miki 1.9k points
Dark theme