Click here to Skip to main content
15,921,276 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I use one trigger with liked server,
one server is SQL Server 2000 and another linked server is SQL Server 2005 these two server i already link. These trigger is use after insert data.
But now ,i facing the following problem.

CSS
OLE DB provider 'SQLOLEDB' was unable to begin a distributedtransaction

[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 0 8004d00a]


Best Regard,
Theingi Win.
Posted

1 solution

First thing is to check that MS DTC service is up and running. Also check these:
- http://support.microsoft.com/kb/839279[^]
- http://support.microsoft.com/kb/329332[^]
 
Share this answer
 
Comments
Theingi Win 11-Aug-11 3:33am    
Thanks ! Mika Wendelius

I want to ask you. This DTC service is need to run both server or not.
Wendelius 11-Aug-11 3:40am    
In order to handle transaction enlistment both ways, yes.
Theingi Win 11-Aug-11 3:41am    
Thanks! for your reply
i will try it.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900