what could be the exact cause of this Error and how to fix?

• sntiwary

  Hall of Fame

  Points: 3475

  More actions

  April 2, 2004 at 5:04 am

  #86321

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

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

  -sntiwary

   

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 2, 2004 at 5:13 am

  #501574

  Article PSS ID306212 describes the case.

  It has basic guide for troubleshooting linked server error 7391.