MSDTC取消了分配交易 [英] MSDTC cancelled distrubution transaction

问题描述

我一直在尝试从安装的SQL Server 2008 SP1运行分布式事务查询。其他服务器也具有相同的配置（SQL 2008 SP1）。



我已在服务器中配置了所有MSDTC选项。服务器中都禁用了防火墙。



我能够创建链接服务器并运行正常查询。它工作正常。但是，如果我使用BEGIN DISTRIBUTED TRAN运行相同的查询，则会收到以下错误：



Microsoft分发事务协调员（MS DTC）已取消Ditribution事务



提前致谢

I have been trying to run a distributed transaction query from SQL server 2008 SP1 installed. Other server is also with same configuration(SQL 2008 SP1).

I have configured all the MSDTC options in both the server. Firewall is disabled in both the server.

I am able to create linked server and also ran the normal query.It worked fine. But if I am running same query with BEGIN DISTRIBUTED TRAN, I am getting error as:

"The Microsoft Distribution Transaction coordinator (MS DTC) has cancelled the Ditribution transaction"

Thanks in advance

推荐答案

查看以下链接，了解有关您问题的建议。 MSDTS

Have a look at the follow link for suggestions on your issue. MSDTS

这篇关于MSDTC取消了分配交易的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！