Need hlep this linked server script

  • hi,

    1. select * from view name - it is working fine

    I can able to access remote database data in sql server 2000 machine by using OPENROWSET,

    If using second option - failed

    2. begin tran

    select * from view name - it is working fine

    commit tran

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

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

    please help, how to resolve it?

  • You need to investigate what is going on with DTC (Distributed Transaction Coordinator)

    Is it running on both machines involved?

    Can the two DTC instances communicate? - it is a long time since I have investigated a problem with this but I found we had a firewall between the two servers and the correct ports for DTC were not opened.

    Historically DTC was installed with SQL server, but at some point it became a Windows component. Either way a review of errors from it in the Event log should point you in the right direction.

    Mike

  • hi,

    Thanks for reply...

    I have checked as you suggested, MS DTC services was stoped at two server,

    if I start these services to enable Network DTC access and INBOUND/OUTBOUND also enabled,

    in this case our Active directoy will stoped after enbale those option.

    thanks

    ananda

  • Ananda

    Just as a matter of interest, why are you wrapping a SELECT statement in an explicit transaction?

    John

  • Not the same exact issue you're facing, but this article[/url] contains a lot of information about DTC permissions to apply on Windows in order to let distributed transactions work.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

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

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