ole db provider error for distributed transactuons

  • The linked machine is called 'DH-32011-W', and we can successfully run the following:

    select * from [DH-32011-W].DataBase.dbo.Table

    However, if we try and run a distributed transaction, like this (please note, this is only a demonstrative example, and is not the sort of query we actually want to do):

    begin distributed transaction

    select * from [DH-32011-W].DataBase.dbo.Table

    commit transaction

    then we get the following error message:

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

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

    the 2 servers are in different domains.

    praveena


    praveena

  • Check the DTC service on both machines. The account may need rights for the other domain.

    Steve Jones

    steve@dkranch.net

Viewing 2 posts - 1 through 1 (of 1 total)

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