SSIS 网络服务
我有一个 SSIS 2005 包，正在使用 SQL 代理作业执行。该包有一个 Web 服务任务，其凭据与用于执行该包的凭据不同。
当我的包在服务器上执行时，我遇到以下问题：
“Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException：System.UnauthorizedAccessException：访问路径.....被拒绝。
包正在执行集群环境。两个帐户都已在服务器上创建，以便包能够写入 TEMP 文件，但问题仍然存在。
I have an SSIS 2005 package which is being executed using an SQL Agent Job. This package has a Web Service Task with different credentials than those being used to execute the package.
I am having the following problem when my package is executed on the Server:
"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: System.UnauthorizedAccessException: Access to the path ..... is denied.
The package is being executed on a clustered environment. Both accounts have been created on the server so that package is able to write to TEMP files but problem still persists.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
基于此线程，您应该能够设置 Web 服务的
OutputLocation属性。需要将其配置为指向调用 Web 服务的用户凭据有权访问的位置。这可能需要管理员修改目录路径上的 ACL。Based on this thread, you should be able to set the
OutputLocationproperty of the webservice. This will need to be configured to point to a location the credentials of the user invoking the webservice will have access to. This might require an admin modifying ACLs on a directory path.在集群环境中，您应该确保写入的位置是集群资源。例如，您可以创建文件共享，但文件共享必须是集群资源，以便在集群故障转移时可用。如果要写入驱动器，请确保该驱动器是依赖于正确 SQL Server 资源的群集驱动器。
In a clustered environment, you should ensure the location being written to is a clustered resource. For example, you can create file share, but the file share must be a cluster resource so that it is available when the cluster fails over. If you are writing to a drive, ensure the drive is a cluster drive dependent on the proper SQL Server resource.