SQL Server Performance

Error: 8510

Discussion in 'SQL Server 2005 General Developer Questions' started by arunv_vijay, Apr 6, 2007.

  1. arunv_vijay New Member

    Distributed Transaction Error
    ------------------------------
    Eniviroinment
    Machine 1 (Transaction Initiator) - Windows 2003 Server with SP1 and DTS Enabled and configiured and settings enabled as per the link below
    Machine 2 - same as above
    Database : SQL SERVER 2005 WITH SP2 Installed
    Hi I am getting an error while running a .NET App and Calling a Transactional Stored Procedure.
    The ADO object makes a call to the Stored Procedure which is wraped between a
    BEGIN DISTRIBUTED TRANSACTION and COMMIT TRANSACTION
    have the XACT_ABORT ON


    Message
    Error: 8510, Severity: 20, State: 2.

    Message
    Enlist operation failed: 0x8004d00e(XACT_E_NOTRANSACTION). SQL Server could not register with Microsoft Distributed Transaction Coordinator (MS DTC) as a resource manager for this transaction. The transaction may have been stopped by the client or the resource manager.


    Kindly suggest on what have to be done on this.This is getting too critical
    Thank You
    Arun Vijayraghavan
  2. MohammedU New Member

  3. ghemant Moderator

  4. satya Moderator

Share This Page