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...b;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?

Hi Jeremy,

"jeremy (AT) nospamwardlawclaims (DOT) com"
<jeremynospamwardlawclaimscom (AT) discussions (DOT) microsoft.com> schrieb im
Newsbeitrag news:F61C0713-43DA-4CE3-920E-35104084357E (AT) microsoft (DOT) com...
Try step 5 from the following article
http://www.support.microsoft.com/?kbid=555017

Helge