msdtc - should I cofigure clustered MS DTC on windows 2012 r2 used for MS SQL server 2014 that runs as failover claster from mentioned 2 machines

Usualy i use ms sql server without high avalability. Usualy I need configure os local ms DTC to my transactionScope transaction works. This transaction are open in c#code in application server and then ms sql server modify DB within transactions. So, in this case local ms dtc configuration is required: allow inbound, outboud traffic, mutual authentification. But is it sufficient to confige local ms DTC on both claster DB machines only or should i configure clastered DTC? Db cluster based on Windows 2012 r2....Read more

MSDTC (Distributed Transaction Coordinator) Service Stops Unexpectedly

I am working on a Windows Server 2008, the MSDTC (Distributed Transaction Coordinator) Service Stops Unexpectedly and I cannot restart it again.When I go to the event viewer this is the error message that I have got:"A critical error occurred in an MS DTC component therefore the process is terminating. The category field identifies the component that encountered the error. Please contact Microsoft Product Support. Error Specifics: hr = 0x80070002, d:\rtm\com\complus\dtc\dtc\msdtc\src\cservice.cpp:473, CmdLine: C:\Windows\System32\msdtc.exe, Pid...Read more

msdtc - Distributed Transaction Coordinator

I am trying make a database transaction(inserting records) across multiple system. So, I decided to use System.Transaction Namespace in .net. I configured MSDTC on both system(But i dont know whether i configured correctly). My transaction has two insert query one will execute at local system. another, will execute at some other system in a local network.First insert query work successfully but second one raise a error like :Message = "The transaction has already been implicitly or explicitly committed or aborted."Please help in this case to ov...Read more

MSDTC/DTCPing works in only one direction

if i set up two windows server 2008 r2 machines, i can get distributed transactions to work in only one direction. when i can get DTCPing to work successfully, the DTC is working. DTCPing, though, only works when i initiate the test from one machine to the other, and not the other way around.let's call my machines app and database.if i start DTCPing on both and key app into the instance on database and press enter, DTCPing reflects success.if i start DTCPing on both and key database into the instance on app, i do not get anything that says th...Read more