SQL Server - 代理代理错误“CryptUnprotectData 失败 (1325)”
作业历史记录:
Message
Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 4). The step failed.
代理日志:
[442] CryptUnprotectData failed (1325).
服务器:
Microsoft SQL Server 2005 - 9.00.3080.00 (X64) Sep 6 2009 09:15:46 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
product_level - SP2
edition - Standard Edition (64-bit)
我已按照两种不同的路径完成了设置:
SQL 代理和 SQL Server 均在属于本地组成员的本地系统帐户下运行,管理员
我不认为这篇知识库文章适用: http://support.microsoft.com/kb/938086
- 不多
- 调用次数错误 消息甚至没有关闭
凭据所指向的帐户也是盒子上的管理员。
SSIS 包未在代理下运行 情况并非如此。
当然,将作业步骤更改为在 sql 代理帐户下运行效果很好。
Job History:
Message
Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 4). The step failed.
Agent Log:
[442] CryptUnprotectData failed (1325).
Server:
Microsoft SQL Server 2005 - 9.00.3080.00 (X64) Sep 6 2009 09:15:46 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
product_level - SP2
edition - Standard Edition (64-bit)
I've done the setup following two different paths:
- replication setup wizard manually,
- specifically following these instructions:how-to-run-sql-server-agent-and-sql-server-jobs-with-least-privilege-in-sql-server-2005
SQL Agent and SQL Server both run under Local System accounts which are members of the local group, administrators
I don't see this kb article as applying:
http://support.microsoft.com/kb/938086
- not a high # of calls
- error messages aren't even close
The account being pointed to by the credentials is also an administrator on the box.
SSIS Package not running under proxy is not the case.
Of course, changing the job step to run under the sql agent account works fine.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论