Results 1 to 1 of 1

Thread: Error 7391

  1. #1
    Join Date
    Jan 2003
    Location
    Surrey, UK
    Posts
    23

    Unanswered: Error 7391 New transaction cannot enlist in the specified transaction coordinator

    I am struggling to get a distributed transaction accross 2 servers working: I cannot even get simple test code to work.....

    BOX_A is defined as a linked server on BOX_B. BOX_B is defined as a linked server on BOX_A.

    BOX_A Win2003 Server SP1 with SQL2K SP3a
    BOX_B Win2000 Server SP4 with SQL2K SP3a

    Network DTC Access is enabled on BOX_A (under add programs)
    MSDTC is running on both servers.

    The servers are on different IP subnets.

    I have tried with and without Aliases.

    This works ok and returns a result:

    Code:
    SET xact_abort ON
    SELECT  *  FROM [BOX_A].[RES].[dbo].tblversion
    GO
    This does not work:

    Code:
    SET xact_abort ON
    BEGIN DISTRIBUTED TRANSACTION
    SELECT  *  FROM [BOX_A].[RES].[dbo].tblversion
    COMMIT
    GO
    The error message is:

    Server: Msg 7391, Level 16, State 1, Line 3
    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].
    I have the identical behaviour from BOX_A to BOX_B

    Can anyone help please....
    Last edited by MealinA; 09-29-04 at 12:56.
    Andy


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •