Error while Insert into linked server thru trigger

Shehzad

Apr 27 2014 10:40 PM

764

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.

Is it allowed to insert into linked server thru trigger ?

Regards

Shehzad