While running a distributed query i am having following problem.
Server: Msg 7391, Level 16, State 1, Procedure t25, Line 8
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].
can any body give any solution for this ?
Either you can use COMCHECK utility downloaded from MS website or
quickest (dirty too) is to Run REGEDT32 from run command and goto the following registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess