MSDTC error

[parsql]

Hi all,



I am getting this error while firing trigger on over the linked server.

I am creating trigger on SQL 2000 database and have linked server (SQL 2005) .



I am createing trigger and i am calling insert statement to insert value in SQL server 2005 table!!

the error is:



[OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

Msg 7391, Level 16, State 1, Procedure ServerChangedTrigger, Line 32

The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction.



please help!!

 

[mrdenny]

I assume that you have already enabled network DTC access in the Add/Remove programs window. If not do so.

Then follow step 2 of this MSKB article

http://support.microsoft.com/kb/839279/en-us.

You don't need to worry about steps 1 or 3 they don't apply to you.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com