If you deploy some DTSX packages to SQL Server, and create an Agent job to run them, you might see this error:
Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B
The workaround is probably simple. When deploying to your SQL Server and you're on the Specify Target SQL Server page of the wizard, select the 'Rely on server storage for encryption':
That should probably do it. If not, check out this thread on MSDN.
Friday, 26 June 2009
SQL Server Job Error: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B
Labels: sql server, sql server agent, sql server error
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment