Saturday 5 October 2013

MSDTC (Distributed Transaction Coordinator)

Few quick notes about MSDTC:

  1. The default full path is (C:\Windows\System32\msdtc.exe)
  2. To start up, use (Net Start MSDTC)
  3. To stop, use (Net Stop MSDTC)
  4. Window service name is (Distributed Transaction Coordinator)
  5. To configure it properly for sql server, we have to enable network DTC access
    1. use (DCOMCNFG)
    2. select (Console Root\Component Services\Distributed Transaction Cooridinator\Loacl DTC\Properties\Security\Security Settings)
    3. Enable "Network DTC Access" and allow remote clients