MSDTC issue on SQL Server clusters

  • GonnaCatchIT

    SSCrazy

    Points: 2793

    Dear All,

    I have sql server 2016 with 5 clustered instances on the box. We are using Local DTC for these.

    currently we have DB's on 2 of these instances. But problem is MSDTC is working on only 1 instance at a time. When we reboot the server, the issue is resolved on 1 instance, but other instance gets affected.

    Can anyone let me know what is the recommended way to setup DTC on cluster's so that it works on all instances.

    Ex:

    begin distributed transaction

    select * from test

    commit transaction

  • GonnaCatchIT

    SSCrazy

    Points: 2793

    More info.. from the DTC logs, I am seeing this

     

    XACT_E_DUPLICATE_GUID

  • GonnaCatchIT

    SSCrazy

    Points: 2793

    Any pointers anyone

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

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