Home Forums SQL Server 2005 Administering The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction RE: The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction

  • December 8, 2011 at 6:20 am

    #1418639

    Lavanyasri (12/8/2011)

    Dev (12/8/2011)

    Before I ask anything related to issue, one general question...

    You started this thread in 'Tuesday, September 06, 2011 4:09 PM'. Your issue is still unresolved? I believe it's not a priority issue. Or you resolved it & it reappeared?

    HI Dev,

    Thanks for the update .

    In the month of sept the issue was resolved by restarting the SQL server .

    The issue is happened again few days back .

    Thanks

    Lavanya

    So you know one solution at least... 🙂

    OR work on following... That's precisely you need to do.

    The maximum number of active transactions that the MS DTC log file can accomodate has been exceeded. You must increase the size of the MS DTC log file if you wish to initiate more concurrent transactions.