Error while using Trigger forinserting data in Linked Server

DRBDRB Member Posts: 105
edited 2012-08-04 in SQL General
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.
-Dhan Raj Bansal
Linkedin Profile: http://in.linkedin.com/in/dhanrajbansal

Comments

  • macuxpcmacuxpc Member Posts: 16
    Could be permissions issues or something else, but what I am wondering is, couldn't you use SQL Replication to transfer the data?
    MacUxPC
    Dynamics-NAV.org
Sign In or Register to comment.