[Solved-1 Solution] Error: 8509 - Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)



Error Description:

  • While having:
    • Clustered Instance of SQL Server.
    • Separate group for MSDTC resource in cluster.
  • This error may occur.

Solution 1:

  • Here are the three commands we can use to fix the mapping.
  • View the mapping
msdtc -tmmappingview *
click below button to copy the code. By - sql tutorial - team
  • Clear the mapping.
msdtc.exe -tmMappingClear -name DTC_INST02_Mapping
click below button to copy the code. By - sql tutorial - team
  • Create correct mapping
Msdtc -tmMappingSet -name DTC_INST02_Mapping -service "MSSQL$INST02" -ClusterResourceName "MSDTC-INST02"
click below button to copy the code. By - sql tutorial - team

Related Searches to Error: 8509 – Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)