MSDTC is short for the Microsoft Distributed Transaction Coordinator. It is a Windows Sevice that SQL Server and other applications rely on when a transaction spans across multiple machines.

learn more… | top users | synonyms

5
votes
1answer
1k views

Using MSDTC in SQL Server 2008

I used Hyper-v to install one windows 2008 server machine, and copy the image to create another one and change the computer name, both of them are in the same domain, and I use a domain user as ...
11
votes
1answer
4k views

AlwaysOn AG, DTC with failover

Problem: How can I run Distributed Transaction Coordinator (DTC) on all servers in an AlwaysOn Availability Group (AG)? I do NOT need to maintain transactions over failover/switchover events. Setup: ...
3
votes
1answer
494 views

Secondary Clustered DTC will not work when Primary goes offline - SQL Server Issues

I've been working on setting up clustered environment with a two new DTC roles, DTC1 and DTC2. I set up DTC1 which allows both clustered VM's and SQL Server Instances to function correctly. However, ...