Solution to the "Report Server cannot decrypt the symmetric key used to access sensitive data or encrypted data in the Report Server Database" error

Source: Internet
Author: User

An error occurred while deploying the report:
The Report Server cannot decrypt the symmetric key used to access sensitive data or encrypted data in the database of the Report Server. You must restore the backup key or delete all encrypted content. For more information, see this document.

Solution: delete all symmetric key instances and all encrypted data in the database of the Report Server, and then recreate the encryption key.

Steps:
Run the following command line:
Rskeymgmt-d-I {234a29c8-64d4-4ab5-98fe-0ad282d9d24b}
Rskeymgmt-s-I

{234a29c8-64d4-4ab5-98fe-0ad282d9d24b} is the instance id of your report service installation. The guid value in the rsreportserver. config file.
See http://msdn2.microsoft.com/zh-cn/library/ms162822.aspx for details

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.