locked
Unable to Start Distributed Transaction between two Clustered Servers RRS feed

  • Question

  • Hello Everyone,

    I have 4 servers, 2 each for application (Dev & Prod)

    DEV 1 & DEV 2 are standalone servers 

    Prod 1 & Prod 2 are Windows Clustered Servers.

    From one application to other we do Distributed transactions. Dev 1 - Dev 2 or Dev 2 - Dev 1 can start DTC and working fine,

    but issue comes when Prod 1 - Prod 2 or Prod 2 - Prod 1. I get error message 

    OLE DB provider "SQLNCLI" for linked server "xyz" returned message "No transaction is active.".
    Msg 7391, Level 16, State 2, Line 3
    The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "xyz" was unable to begin a distributed transaction.

    I have tested Dev 1 - Prod 1, Dev 1 - Prod 2, Dev 2 - Prod 1, Dev 2 - Prod 2 everything is working fine only Production servers are causing issue.

    I enabled all settings needed for DTC on Cluster MSDTC service but no luck.

    Please help me. Thanks in Advance.

    Thursday, July 2, 2015 6:39 AM

Answers

All replies