Post reply

Distributed Transaction failure

  • October 22, 2005 at 1:19 am

    #90418

    Distributed transaction is throwing the below error:

    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x8004d00a].

    [OLE/DB provider returned message: New transaction cannot enlist in the specified transaction coordinator. ]

    Details:Windows 2000 sp3, Sql Server 2000 sp4, MSDTC running

     

     

    Cheers,

    Dhiry

    SQL Server DBA

  • October 22, 2005 at 9:07 am

    #599359

    Is the client Windows 2003 or XP ?

    There are a couple of reasons:

    For Windows XP, Windows Firewall is enabled on the computer. By default, Windows Firewall blocks the MSDTC program.

    See http://support.microsoft.com/?kbid=873160

    Installing Windows Server 2003 SP2

    See http://support.microsoft.com/?kbid=839279

    SQL = Scarcely Qualifies as a Language

  • October 24, 2005 at 5:04 am

    #599440

    Client is Windows 2000

    There is no firewall problem.

     

    Cheers,

    Dhiry

    SQL Server DBA

  • October 24, 2005 at 6:59 am

    #599456

    Does any ends of the distributed query involves an windows 2003 OS or XP SP2 ?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply