Problem with distributed transaction SP.

• Vladimir Sim

  Ten Centuries

  Points: 1310

  More actions

  March 23, 2006 at 5:31 am

  #168190

  Hi,

  I am working on have 02 machine WinXP Professional with SP2 and

  SQL2k developer with SP4 install. They are machine A and B.

  I have enable DTC and disable WinXP firewall plus enable the port 135 for MS DTC.

  I have enable setup linked server,MB from machine A

  I can execuate local SP and remote server SP without any problem.

  However, when I try to execuate local SP like the pseud code

  below that call local SP and remote SP, it will give me the error.

  I ha

  Server: Msg 7391, Level 16, State 1, Procedure a_test_Update, Line 19

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

  >>PSEUD CODE<< SET XACT_ABORT ON
  SET REMOTE_PROC_TRANSACTIONS ON
  BEGIN DISTRIBUTED TRANSACTION

  exec local SP

  exec remote SP

  COMMIT TRANSACTION

  Please advise me how to fix this error. I have try out numerous
  method from MS Knowledge based but all in vain.

  Thank you

• Jo Pattyn

  SSC-Dedicated

  Points: 32352

  More actions

  March 23, 2006 at 12:05 pm

  #628444

  Have a look at http://support.microsoft.com/kb/839279

  it is the "full" version of the problem description.