I have configured a linked server using SSMS between two sql servers 2008 R2. Now I wrote a trigger on Server1 to insert row into Server2. I also enabled DTC and started it. When I execute the insert command, I get the following error.
The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Server2" was unable to begin a distributed transaction.
Please help me to sort out the problem.