SSIS 包失败并显示“无法获取连接"错误 [英] SSIS Package failing with "Failed to acquire connection" error

问题描述

我们有一个从 Web 服务启动的 SSIS 包.在 Dev 环境中，一切正常，但在 QA 环境中，我在尝试运行包时收到以下错误:无法获取连接 [ConnectionName].连接可能未正确配置，或者您可能没有正确的权限这种联系."

We have an SSIS package that is launched from a web service. In the Dev environment, everything works fine, but in the QA environment I get the following error when trying to run the package: "Failed to acquire connection [ConnectionName]. Connection may not be configured correctly or you may not have the right permissions on this connection."

连接使用SQL登录，未集成.登录名本身具有适当的权限.SSIS 包位于文件系统上，而不是 SQL 服务器上.我使用了 DTCPing，并且在 SQL 服务器和实用程序服务器之间一切正常.不幸的是，我对 SSIS 本身知之甚少，对于可能是什么问题我有点不知所措.任何建议将不胜感激.

The connection uses SQL login, not integrated. The login itself has the appropriate privileges. The SSIS package is located on the file system, not on SQL server. I've used DTCPing and everything checks out fine between the SQL server and the Utility server. Unfortunately I know very little about SSIS itself, and am a bit of a loss as to what could be the problem. Any suggestions would be greatly appreciated.

推荐答案

我终于解决了这个问题，它与我的 MSDTC 设置有关.虽然 MSDTC 已启用，但我必须启用以下设置:

I finally resolved the problem and it was related to my MSDTC settings. While MSDTC had been enabled, I had to enable the following settings:

• 网络 DTC 访问
• 允许远程客户端
• 允许入站/出站
• 启用提示

这篇关于SSIS 包失败并显示“无法获取连接"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！