Lemonde
  • Lemonde
  • 100% (Exalted)
  • Advanced Member Topic Starter
6 years ago
We are seeing the following on our SQL 2014 server:
The Distributed Transaction Coordinator service terminated with service-specific error %%-1073737712.

Details:

Log Name: System
Source: Service Control Manager
Date: 18/07/2017 21:29:33
Event ID: 7024
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: servername.domain.suffix
Description:
The Distributed Transaction Coordinator service terminated with service-specific error %%-1073737712.
Event Xml:



7024
0
2
0
0
0x8080000000000000

382209


System
servername.domain.suffix



Distributed Transaction Coordinator
%%-1073737712


Sponsor

Want to thank us? Use: Patreon or PayPal or Bitcoins: bc1q4whppe29dw77rm4kv4pln0gqae4yjnxly0dny0hky6yhnafukzjsyrsqhk

All opinions expressed within these pages are sent in by members of the public or by our staff in their spare time, and as such do not represent any opinion held by sircles.net Ltd or their partners.


Lemonde
  • Lemonde
  • 100% (Exalted)
  • Advanced Member Topic Starter
4 years ago
The log file under %systemroot%\system32\msdtc had become corrupted.

We were seeing another message saying:

MS DTC log file not found. After ensuring that all Resource Managers coordinated by MS DTC have no indoubt transactions, please run msdtc -resetlog to create the log file.

So we cleared out the windows\system32\MSDTC folder and ran msdtc -resetlog which then started.

We also saw:

MS DTC started with the following settings:

Security Configuration (OFF = 0 and ON = 1):
Network Administration of Transactions = 0,
Network Clients = 0,
Inbound Distributed Transactions using Native MSDTC Protocol = 0,
Outbound Distributed Transactions using Native MSDTC Protocol = 0,
Transaction Internet Protocol (TIP) = 0,
XA Transactions = 0

In the log following the start-up.