sql server dts: Distributed transaction on linked server. -- sql server dts

Distributed transaction on linked server.

jeremy NO[at]SPAM nospamwardlawclaims.com
4/28/2005 2:40:01 PM

sql server dts:

I have a Windows 2003 server running SQL Server 2000 with a linked server on
Windows 2000 server running SQL Server 2000. Both machines are on the same
domain and Distributed Transaction Coordinator is running. I have applied
the instructions in KB article 817064 (
http://support.microsoft.com/default.aspx?scid=kb;en-us;817064 ).

I am receiving the following error message from a .NET windows service when
running a stored procedure that includes a SELECT on a View which queries a
table on a linked server.

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].

Does anyone know how I can fix the error above?

Re: Distributed transaction on linked server.

Helge C. Rutz
4/29/2005 12:00:00 AM

Hi Jeremy,

"jeremy@nospamwardlawclaims.com"
<jeremynospamwardlawclaimscom@discussions.microsoft.com> schrieb im
Newsbeitrag news:F61C0713-43DA-4CE3-920E-35104084357E@microsoft.com...
[quoted text, click to view]

Try step 5 from the following article
http://www.support.microsoft.com/?kbid=555017

Helge