SQL SERVER and MS DTC

  • When I ran a new job, it failed and SQL log shows: "The connection has been lost with Microsoft Distributed Transaction Coordinator (MS DTC). Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) will begin once the connection is re-established. This is an informational message only. No user action is required."

    Check job history: it shows: "Unhandled Exception: System.Transactions.TransactionException: The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025) ---> System.Runtime.InteropServices.COMException (0x8004D025): The partner transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D025)"

    Modified DTC setting and reboot the server, still has the problem.

    Now my question is: how sql server calls DTC service and uses it?

    Which configuration should I check for this issue from SQL side?

    Thank you for your help

  • To be more clear to my question: which configuration in SQL Server can block DTC connection?

  • It has been a long time since I have dealt with MS DTC errors between servers. You need to check the configuration of MS DTC on both servers to be sure that they can properly communicate.

    Sorry I can't provide more details, but it has been 8 or 9 years since I dealt with it.

  • Worked with OS team and the programmer, found the program was wrong, pointing to the wrong server.

    Thank you for your reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply