sql server connect: Error on inserting record on remote server -- sql server connect

Error on inserting record on remote server

doller
9/26/2005 6:47:58 PM

sql server connect:

Hi,

I get this error when i insert a record from my local server to a
remote server.

Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line
14
The operation could not be performed because the OLE DB provider
'SQLOLEDB' was unable to begin a distributed transaction.
[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].

pls help me

from
Doller

Re: Error on inserting record on remote server

Dandy Weyn [Dandyman]
9/28/2005 11:26:03 AM

MSDTC might not be started on one of the servers

--
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net

Check my SQL Server Resource Pages at http://www.dandyman.net/sql
[quoted text, click to view]