Failed to decrypt protected XML node.

by | May 30, 2008 | Microsoft, SQL server | 0 comments

I had strange problem with SSIS package. I made my package in Visual Studio, all tests ran without a problem at PC station. But when I upload it to production SQL server 2005 machine job failed… What’s going on? Error message was strange: “Description:Failed to decrypt protected XML node “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.“ Solution was simple. My package use FTP connection. To save FTP password in my package I had to protected it with a password. And it seems that to decrypt it use account of user which create package. So I copy VS solution to SQL server and opened it with windows SQL server agent account. Then I save it and load to SQL server Integration services. And it works.

Written by Tomasz Szulczewski

Hi, my name is Tomasz Szulczewski, and I have been in love with information technology for over 25 years, but I still have an IT passion and feel like a geek. I am a person who is problem solver who thinks that not all people must be experts in IT.

Related Posts

Ignite 2018

Ignite 2018

I'm starting to write this post when Ignite 2018 is approaching the end, so the time is preparing for a summary. A year ago, when I wrote about Ignite 2017, I thought that the conference was presenting revolutionary solutions to the market in many areas. I had a sense...

read more

0 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.