为什么 SSIS Runtime 启动分布式事务失败? [英] Why does the SSIS Runtime fail to start the distributed transaction?

问题描述

在为 SQL Server 2008 创建 SSIS 包时，我遇到了以下错误:

While creating an SSIS package for SQL Server 2008 i run into the following error:

错误:SSIS 运行时未能启动到期的分布式事务错误 0x8004D01B 交易经理不可用.".DTC事务无法启动.这个可能是因为 MSDTC 服务没有运行.

Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running.

我正在我的机器上本地创建和运行程序包，但数据库位于运行 Windows Server 2008 的服务器上，该服务器不在域中.

I'm creating and running the package locally on my machine but the database is on a server, running Windows Server 2008, which is not in the domain.

我已确保在本地和服务器上都启动了 DTC 服务，并添加了 Windows Vista 防火墙中预定义的防火墙例外.

I have made sure that the DTC service is started both locally and on the server, and I have added the Firewall exceptions that are predefined in the Windows Vista firewall.

为什么 SSIS Runtime 无法启动分布式事务?

Why does the SSIS Runtime fail to start the distributed transaction?

推荐答案

我遇到了同样的问题，但是 MS DTC 没有在我的机器上运行.要打开事务协调器，我必须执行以下操作:

I had the same problem, however, MS DTC was not running on my machine. To turn on the Transaction Coordinator I had to do the following:

启动 MS DTC

1. 要打开服务，请在开始"菜单上，单击控制面板".
2. 在控制面板中，单击管理工具.
3. 在管理工具中，单击服务.在详细信息窗格中，单击Distributed Transaction Coordinator 在服务列表中.
4. 在操作"菜单上，单击开始".

这篇关于为什么 SSIS Runtime 启动分布式事务失败?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！