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.
3
votes
1answer
202 views
Cross Database transactions - Always on
Recently we are working on a POC to get Always on work and happened to see this article in BOL
http://technet.microsoft.com/en-us/library/ms366279.aspx
This article suggests that there would be ...
1
vote
1answer
43 views
SSIS Suddenly Requires DCOM Permissions
I have recently deployed some SSIS packages. I made a job to run them one after another. However, I am now allowed to use MSDTC. So I chained the jobs together like I have done before, but now I am ...
0
votes
1answer
97 views
MSDTC on SQL Server 2012 with mount point for data disk
I have installed a new SQL Server 2012 instance on a cluster. The installation went fine but when I've added the MSDTC as resource of the instance, it went wrong. When I just added it, the MSDTC was ...
2
votes
1answer
650 views
Msg 7391, Distributed Transactions (DTC) on SQL Server
This may be DBA related or developer related, I honestly don't know.
I have two Database servers:
A: SQL Server 2005 (Trigger that uses DBMail on Server B)
B: SQL Server 2008 R2 (DBMail configured)
...
3
votes
0answers
144 views
MS DTC errors on SQL Server 2008 R2 but not SQL Server 2000 running on difference instance
I am receiving errors when I try to run a distributed query against different SQL Server 2008 R2. At first I thought this might be cause the servers have been set up on a VM using a clone but after I ...
4
votes
1answer
499 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 ...
