October 16, 2014 at 12:49 am
We have created a linked server.We are getting below error when a trigger is executed from the source server.
1)OLE DB provider "SQLNCLI" for linked server "Destination server" returned message "The partner transaction manager has disabled its support for remote/network transactions."
2)Msg 7391, Level 16, State 2, Procedure trgScandetails, Line 21
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "Destination server" was unable to begin a distributed transaction.
3)OLE DB provider "SQLNCLI" for linked server "Destination server" returned message "No transaction is active."
Please help me on this.
Thanks in advance.
October 16, 2014 at 1:52 am
In order to start a distributed transaction, you need to configure the Distributed Transaction Coordinator (DTC).
See here for instructions: http://support.microsoft.com/kb/2027550/en-us
-- Gianluca Sartori
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply