Distributed transaction on linked server.

Tech-Archive recommends: Fix windows errors by optimizing your registry

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?

.

Relevant Pages

  • Re: UPDATE Statement Involving Tables in Different Databases
    ... 'SQLOLEDB' was unable to begin a distributed transaction. ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ... Distributed Transaction Coordinator to make sure that it's ...
    (comp.databases.ms-sqlserver)
  • Re: Creating a Trigger which updates a linked server
    ... But the problem is not the @@error message or else!!! ... the trigger start and i wait until the connection is ... > BEGIN DISTRIBUTED TRANSACTION ... >> COMMIT TRAN ...
    (microsoft.public.sqlserver.programming)
  • Re: Login failed for user sa
    ... begin distributed transaction ... This is the error message: ... OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ...
    (microsoft.public.sqlserver.replication)
  • dcomcnfg Probleme
    ... Fehlercode 8004E00F - COM+ konnte keine Daten mit dem Microsoft ... Distributed Transaction Coordinator austauschen. ... Das Ereignisprotokoll enthält möglicherweise weitere Informationen zur ...
    (microsoft.public.de.german.windowsxp.sonstiges)
  • RE: MSDTC error 4404
    ... After checking the event log information you provided, I assume that the Distributed Transaction Coordinator on your ... please reset the msdtc dtclog log and this allowed the DTC service to come up. ... Transaction Coordinator service with all the default settings, like making sure it runs under the NT AUTHORITY ...
    (microsoft.public.windows.server.sbs)