The Distributed Transaction Coordinator (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems. MSDTC is included in Windows 2000 and later ...

learn more… | top users | synonyms

3
votes
1answer
4k views

MSDTC - Communication with the underlying transaction manager has failed (Firewall open, MSDTC network access on)

I'm having problems with my ASP.NET web forms system. It worked on our test server but now we are putting it live one of the servers is within a DMZ and the SQL server is outside of that (on our ...
1
vote
1answer
435 views

Does Sql Server Express supports MSDTC

I need MSDTC(Microsoft Distributed Transaction Coordinator) in one of my application. I am not sure whether it is available on Sql Server Express editions. I googled on MSDN and haven't got clear ...
1
vote
1answer
108 views

Failed to Attach DB on replicated SAN

We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server. Our web servers ...
1
vote
1answer
362 views

SQL 2005 Cluster - How to move MSDTC

We currently have a 2 node (Win2003) SQL 2005 Cluster running 2 instances. We need to move all drives to a new SAN but are pondering over how to move the DTC that is currently 'logging' te Quorum ...
0
votes
1answer
168 views

BizTalk/MQ - DCOM was unable to communicate with the computer xxx using any of the configured protocols

I've read the other questions on this same error, but don't see a close match to this scenario. We got 18 of these last night between 12:17:13 and 12:39:37 on Win 2008/R2. It caused us to lose ...
0
votes
1answer
188 views

MSDTC - COMException

We currently have 4 load balanced web servers connecting to a SQL 2005 database server. On the web servers is IIS 6 which has our Dot Net web services installed and Dot Net COM+ components also in Dot ...
-1
votes
1answer
612 views

MSDTC Port 135 open bi-directionally

I have two servers, a web application server and an SQL Server database running on its own server. I have a firewall between these two servers. Do I have to open port 135 on both the SQL Server and ...
2
votes
0answers
15 views

MSDTC is unavailable, but only in one direction?

I have DTC enabled on 2 servers - a web server, and a database server. There are a few places in our web applications where we need to use DTC (via a TransactionScope) to manage transactions ...
2
votes
0answers
673 views

Distributed Transaction failure with Windows Server 2008

I'm having a problem with a new server setup. Distributed Transactions started by the application server to the new server are failing, but they work fine with an existing database server. I need ...
1
vote
0answers
28 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
1
vote
0answers
190 views

Problems with DTC and IBM MQ

I've just run DTC Ping to try to find the cause of a MQ problem. It says the following: ++++++++++++Validating Remote Computer Name++++++++++++ 10-18, 10:30:31.508-->Start DTC connection test ...
1
vote
0answers
600 views

SQL Server 2012 - Linked Server to SQL Server 2000

I'm trying to use the SQLNCLI 10 driver to set up a Linked Server to a legacy SQL Server 2000 instance on our network. I understand you cannot use Version 11 as it doesn't support SQL Server 2000 ...
1
vote
0answers
200 views

What is the linux equivalent of MSDTC?

Windows has MSDTC to coordinate transactions across different resources. What is the equivalent technology in Linux?
1
vote
0answers
817 views

Weird Windows 2003 MSDTC and SQL 2005 issue

scenario: Windows 2003 sp2 x64 enterprise edition. SQL 2005 sp2 cu9 x64 Enterprise edition After restarting the resource groups on two node active-active cluster, 3 SQL 2005 instances start up fine. ...
0
votes
0answers
36 views

SQL DTC Failover Scenario

We had an interesting scenario in our clustered production environment last week. SQL 2008/R2 two boxes clustered on Win 2008/R2 in Active/Passive mode. On the active node A, the clustered MS/DTC ...