Failed to decrypt protected XML node

I got the following error scheduling a SQL 2000 Legacy DTS on a SQL 2005 using DTExec:

Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2007-04-11 08:56:27.19 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

The easiest solution was scheduling it using DTSRun:

dtsrun /SMyServerName /E /NMyDTSName
Tags: ,

About author

Vittorio Pavesi

4comments

  1. Nazir Ahmed
    12:49 PM

    I had the same problem but i managed to solve this.
    have a look at following steps.

    1. Right click on selected package and click run pacakge.

    2. It will show you setting page where you can cahnge duifferent option here.

    3. select connection managers tab and make sure there is user name and password defined correctly.
    3. go to command line and copy run command.

    now you have two option to run this one is through SQL agent Job or command prompt.

    i am running through SQL Ajent Job by executing step as operation system (cmdexec).

    working f9 for me!!!!

  2. Nazir Ahmed
    12:54 PM

    Hi,

    I forgot one thing i am executing package with dtexec.exe on SQL server 2005.

    dtexec /DTS "\MSDB\Default Audit Rules Check" /SERVER servername /CONNECTION "connectionanme";"\"Data Source=servername;User ID=sa;Password=xxxxx;Initial Catalog=xxxxx;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;\"" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V


    cheers

  3. Thanks for your comment !

  4. darius_bujor84@yahoo.com
    9:22 AM

    I have a job which execute 6 packages(the job has 6 steps) planned to run at 1 hour.Sometimes I 've got this error message and the job fails.I mentioned that i have 2 config files from which the dts reads the connections settings...

    Message
    Executed as user: TRS-CLUJ\transart. ... 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:30:06 PM Error: 2008-12-01 17:30:06.82 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-12-01 17:30:06.83 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Error: 2008-12-01 17:30:08.12 Code: 0xC002F210 Source: Execute ImportComercialCondit... The package execution fa... The step failed.

Post a Comment