locked
The partner transaction manager has disabled its support for remote/network transactions....When inserting during trigger in linked server RRS feed

  • Question

  • Hi All,

    I am getting below error while inserting into Linked Server (sql2012) thru trigger from sql2008 ....However if i insert the same thru Store Procedure it is inserting successfully....MSDTC service is started on both sql server machines....also both machines rebooted....but still i am facing this error.


    OLE DB provider "SQLNCLI" for linked server "XXX.XXX.XXX.XX" returned message "The partner transaction manager has disabled its support for remote/network transactions.".
    Msg 7391, Level 16, State 2, Procedure ins_test, Line 11
    The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "XXX.XXX.XXX.XX" was unable to begin a distributed transaction.

    Could assist to resolve. 

    Regards

    Shehzad

    Friday, April 25, 2014 10:17 AM

Answers