Re: Linked Server : SQL Server 2000

From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 02/04/04


Date: Wed, 4 Feb 2004 11:19:20 -0500

Venugopal,

Is the Distributed Transaction Coordinator running? On both servers? And
is it configured according to:
http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

A discussion of linked servers can be found in the article "Linked Servers
and Distributed Transactions"
http://tinyurl.com/2xnsv

Russell Fields
"Venugopal" <vemuriv@hotmail.com> wrote in message
news:9e1c01c3eac1$61eb1590$a601280a@phx.gbl...
> Hi,
> When I try to update a table on my local server by
> referring to another table in the the linked server I get
> a message "Server: Msg 7391, Level 16, State 1, Line 1
> 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]."
>
> Any ideas would be appreciated as I am running short of
> time.
> Regards,
> Venugopal