March 31, 2016 at 12:08 pm
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
March 31, 2016 at 2:04 pm
To be more clear to my question: which configuration in SQL Server can block DTC connection?
March 31, 2016 at 2:36 pm
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.
April 1, 2016 at 12:13 pm
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