DTC unable to begin a distributed transaction

  • Hi,

    I have a sql server 2000 sp 3 on a windows xp sp2. I run this code in query analyzer :

    SET XACT_ABORT ON

    begin distributed transaction

    SELECT * FROM OPENROWSET('SQLOLEDB', 'p118'; 'user'; 'pass', [testdb]..testtable)

    commit tran

    I get this exception :

    Server: Msg 7391, Level 16, State 1, Line 5

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

    p118 is in fact my local machine. I'm just trying to develop an application that should access a remote machine but unfortunatly I have only one server for now (my machine).

    my @@servername returns the right machine name.

    I have been to the component service and changed the security to allow remote client,  inbound and outbound, selected no authentication required. The dtc is started and the account that starts the service is "NT AUTHORITY\NetworkService"

    I get this message in the sql server 2000 log :

    Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

    I've search everywhere and can only find solutions that doesn't work for me.

     

    Thanks for your help

     

    Laurent

     

  • Hi Laurent,

    Try this link http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

     

    Elaine

  • I already did that. No success.

    Laurent

  • Back to basics - is the MS DTC service running and what account is it running under?

    AT

  • MS DTC is running as "NT AUTHORITY\NetworkService".

    In the component services, I have checked :

    - Network DTC Access

    - Allow Remote Clients

    - Allow Remote Administration

    - Allow Inbound

    - Allow outbound

    - No Authentication Required

    My windows firewall is disabled.

     

    Laurent

  • You have to apply Elaine's fix and do a re-boot of your server for the changes to take affect.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply