SQL Server maintanenceplan fails to decrypt the protected XML node "DTS: Password". The error code 0x8009000b is resolved.

Source: Internet
Author: User

The backup job generated by the tool is running normally for many months, but was told by another database engineer that it was not running for a while, so it was disabled. The history log is as follows:

 

There is a key in the error prompt, and so on, but I have not generated a key or something. The cause is that the protection level specified by the package is incorrect.

Solution:

1. log on to the server, click Register Server, and find the SSIS server.

2. Select the faulty package

3. Select the export package. By default, the user key is used to protect sensitive data at the protection level. You can choose to rely on the server .... You can.

 

4. Rename the exported new package

5. Locate the faulty job on the SQL Agent and point it to the new package path again. Delete the problematic package and run the job.

 

Although there are related fault handling instructions on the Internet, it is still quite good to run it by yourself.

 

The next time the old lady goes on a business trip, who will be down to the job of the old lady and kill him?

Related Article

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.