Post reply

Linked servers in a cluster environment

  • August 29, 2006 at 8:54 am

    #172331

    Anybody know of known issues when querying a linked server in a clustered environment? This is my error:

     

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

  • August 29, 2006 at 10:06 pm

    #657420

    Ensure that MSDTC is properly configured as part of the cluster, right alongside MSSQL and SQLAgent.  It is necessary for distributed transactions.

    -Eddie

    Eddie Wuerch
    MCM: SQL

  • September 1, 2006 at 2:37 am

    #657967

    Chris

    MSDTC is configured differently on a cluster server, using the comclust utility.  You should be able to find plenty of information on this on the Microsoft website and elsewhere.

    John

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

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