Error while using Trigger forinserting data in Linked Server

DRB

Hi,
I am created a trigger on SQL Server's table for inserting data into a table on Linked Server and getting following error:



7391,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "ServerName" was unable to begin a distributed transaction.
7412,"01000",[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "SQLNCLI10" for linked server "ServerName" returned message "No transaction is active.".
"
The issue is happening in Trigger only, whereas using a query I am able to write/fetch data to/from that particular table in Linked Server.

What I have already tried: On some of the blogs, it was mentioned that one should
Stop MSDTC Service
Un-install MSDTC Service
Install MSDTC Service
and restart both the servers. This I have already tried.

Can someone please suggest the possible solution for this issue. Thanks in advance.

macuxpc

Could be permissions issues or something else, but what I am wondering is, couldn't you use SQL Replication to transfer the data?