the report server was unable to validate the integrity of encrypted data in the database (rscannotvalidateencryptdata) keyset does not exist (exception from HRESULT:0x80090016) in sccm reporting

Question

Hi, I am Rubiat.

Few months ago my SCCM server was corrupt and then I restore it. My Database server is separate. No, my all service is running smoothly but I am facing an issue. When I want to check any report from my sccm server, then I found that "No items found". No reports are found in SCCM. When I check this from my DB server. I got the same issue. Then, I troubleshoot it and I configured the sql report service with sccmsqlsvc service account. And now I am facing the following issue and no items found in sccm reports.
![180825-image.png][1]

How to fix this issue. Please provide me any suggestion. Thank you.

Answer 1

Hi, @Md. Rubiat Haque

Thank you for posting in Microsoft Q&A forum.

The error message means: The report server is unable to decrypt and use any data that is encrypted with the current key.
You may refer below articles to get the appropriate solution:
https://businesswintelligence.com/content/64/ssrs-pbirs-encryption-key-integrity
(Please Note: Since the website is not hosted by Microsoft, just for your reference.)
https://social.technet.microsoft.com/wiki/contents/articles/52585.ssrs-troubleshooting-the-report-server-was-unable-to-validate-the-integrity-of-encrypted-data-in-the-database.aspx

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.