Blog Stats
  • Posts - 17
  • Articles - 2
  • Comments - 16
  • Trackbacks - 1

 

Sql Server DTC Error

SQL Server DTC Error

Error Message:

Server: Msg 7391, Level 16, State 1, Procedure p_SP1, Line XThe 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].

Resolution

See http://support.microsoft.com/default.aspx?scid=kb;en-us;329332
and
http://support.microsoft.com/?kbid=899191

Here is an excellent explanation from David Adamson’s blog (http://www.dotnetjunkies.com/WebLog/daveadamson/archive/2005/11/22/133928.aspx).

Feedback

No comments posted yet.


Post a comment





 

 

 

Copyright © Shailen Sukul