Msg 7391, unable to begin a distributed transaction.
Hi:
From SQL2005 server1 database DB1 tableA there is a trigger need to insert record to a remote server2 DB2 tableB, but with following error:
OLE DB provider "SQLNCLI" for linked server "server2" returned message "The transaction manager has disabled its support for remote/network transactions.".
Msg 7391, Level 16, State 2, Procedure trInsUpdDel_Ability, Line 156 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "server2" was unable to begin a distributed transaction.
I tried on Server2 side:
A. SET REMOTE_PROC_TRANSACTIONS ON
B. sp_configure 'remote proc trans', 1
reconfigure with override
but still with above error when trigger fires from server1 DB1.
thanks
-D