急,各位高手,请进来,如何解决!

fengglory 2007-07-05 11:10:28
近日碰到一个问题,我做了一个Job来运行SSIS包,但这个Job运行时,总是报如下错误:
-----------------------------------------------------------------------
Message
Executed as user: CM-DEVDW\SYSTEM. ...on 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:55:13 AM Error: 2007-07-05 10:55:13.49 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: 2007-07-05 10:55:13.49 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: 2007-07-05 10:55:14.27 Code: 0xC0202009 Source: CM-Angel Connection manager ... The package execution fa... The step failed.
------------------------------------------------------------------------
不知各位高手,这个是什么原因造成,如何解决!
...全文
323 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
zjcxc 2007-07-05
  • 打赏
  • 举报
回复
设置敏感信息加密方式是在包的 ProtectionLevel 属性中
echiynn 2007-07-05
  • 打赏
  • 举报
回复
错误描述:解密受保护的XML节点"DTS:Password"时失败,错误号0x8009000B

您可能没有被授权访问该信息,请确认密码正确并且可用
----------------------------------------------------------------

大概就这意思,呵呵
zjcxc 2007-07-05
  • 打赏
  • 举报
回复
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

----------------------------------------------------------
包的安全性设置问题, 你在Visual Studio中设计包的时候, 将保护敏感数据的选择设置为使用密码, 然后再在job中重新配置一下调用包, 并设置包的密码即可.

22,207

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 疑难问题
社区管理员
  • 疑难问题社区
  • 尘觉
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧