June 16, 2008 at 11:15 am
Hi,
I am getting the following error when I run a job and from the online tutorials it is suggesting to change the protection level of the package. The only thing is that I don't know how to do that nor could I find any instructions online how to do it. I am new to SQL so I would appreciate any help.
Description: Failed to decrypt protected XML node "PackagePassword" 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-05-06 09:37:58.32 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "SQLPassword" 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.
June 16, 2008 at 11:50 am
you may find the solution in the link given below...I have the similar error..
June 16, 2008 at 11:44 pm
hey,
Really nothing to it....
On your solution explorer, make sure that you select the package you want to change.
In your properties window, you will find all kinds of properties relating to your package. You are looking for the Security section.
There are 2 options in here that you can set, the password, and the package protection.
Good luck!
~PD
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply