Msg 8510, Level 20, State 3, Line 17
Enlist operation failed: 0x8004d01d(XACT_E_CONNECTION_DENIED). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.
I was using Linked Server between two Local Area Network Server,
I was trying insert data from Sql server 2008 to sql server 2005 with nest looping, it pop up this error.