从 SSIS 目录执行包时无法访问网络共享 [英] Can't access a network share when executing a package from the SSIS Catalog

问题描述

我目前遇到一个问题，我可以从 SQL Server Data Tools 完美地执行包，但在尝试从 SSIS 目录中执行时出现以下错误:

I'm currently having an issue where I can execute a package perfectly fine from SQL Server Data Tools but get the following error when trying to execute from within the SSIS Catalog:

文件系统任务:错误:发生错误并显示以下错误消息:拒绝访问路径 '\xxxxxxxx\xxxx\'."."

File System Task:Error: An error occurred with the following error message: "Access to the path '\xxxxxxxx\xxxx\' is denied.". "

我正在使用相同的登录详细信息登录 SSMS 和 SSDT，但我的印象是，从 SSIS 目录执行时，使用了登录 SSMS 时提供的凭据?

I'm logging in to SSMS and SSDT using the same log in details and was under the impression that when executing from the SSIS Catalog the credentials supplied when logging in to SSMS were used?

为了清楚起见，我说的是直接从 SSMS 中的菜单执行:

Just for clarity, I'm talking about executing directly from the menu in SSMS:

[]

推荐答案

听起来您的 SQL Server 上没有配置 Kerberos(双跳问题).

It sounds like you don't have Kerberos configured on your SQL Server (double hop issue).

这是用 MS 记录的问题，现已修复.https://connect.microsoft.com/SQLServer/feedback/details/767088/with-the-new-ability-to-execute-ssis-packages-from-tsql-kerberos-delegation-应该支持

Here is the issue logged with MS which has been fixed now. https://connect.microsoft.com/SQLServer/feedback/details/767088/with-the-new-ability-to-execute-ssis-packages-from-tsql-kerberos-delegation-should-be-supported

这是一篇关于此细节的精彩博客文章:http://www.sqlscientist.com/2014/01/setup-kerberos-authentication-for-sql.html

Here is a great blog post on the details of this: http://www.sqlscientist.com/2014/01/setup-kerberos-authentication-for-sql.html

配置完成后，您应该能够使用本地计算机上的存储过程或 SSMS 远程启动作业.如果配置正确，它将传递您的凭据，当然您必须确保您具有访问网络资源的适当权限.

Once this is configured, you should be able to remotely kick off the job using a Stored Procedure, or SSMS on your local machine. It will pass your credentials if it is configured correctly, of course you have to make sure you have the proper permissions to access the network resource.

这篇关于从 SSIS 目录执行包时无法访问网络共享的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！