August 29, 2006 at 8:54 am
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
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
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