SQL Server Performance

Problem with MS DTC

Discussion in 'SQL Server Clustering' started by jllcardona, Apr 3, 2007.

  1. jllcardona New Member

    I try to install sql server 2000 cluster over a ms windows 2003 EE cluster.

    The microsoft cluster is already running and as first step for the installation of the sql server cluster I installed the MS DTC.

    First I installed the network component on both servers. After it, I configured the different ressources for the ms dtc cluster group. All started (the ip address ressource, the network name ressource and the physical disk ressource ) excepting the msdtc-ressource.

    First I get the following message in the event viewer "MS DTC cannot start because it failed to initialize the log file for its first usage after a cluster install. Please try to restart MS DTC"

    I tried to restart the service from the cluster administrator, and now i get only the message "Cluster Ressource 'MSDTC Ressource' in Ressource Group 'MSDTC Group" failed".

    I looked at the cluster.log file and I couldn't find something significant.

    The msdtc.log don't have legible data.

    Can somebody give me an idea what should i do ?

    Thanks in advance

    Josep Lluis Cardona
    Bremen (Germany)
  2. MohammedU New Member

    Check Application and system log for errors...
    Try to run "msdtc -resetlog"... still the problem then delete the msdtc log file then reset again...

    Check the following too...

    How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster
    http://support.microsoft.com/kb/301600

    The Microsoft Distributed Transaction Service Does Not Start and Error 3221229584 Is Logged
    http://support.microsoft.com/default.aspx?scid=kb;en-us;205069


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. jllcardona New Member

    I already read the articles, followed the installation instructions from the first (How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster)
    and tried to solve the problem with the second (The Microsoft Distributed Transaction Service Does Not Start and Error 3221229584 Is Logged).

    It didn't run.

    But now I call the "msdtc -resetlog" command, delete the log file (that in windows 2003 is placed in %SystemRoot%System32MSDTC and no more in SystemRoot%System32Dtclog) and call the reset command again. After it I could start the msdtc service.

    Thanks a lot for the information.



    Josep Lluis Cardona
    Bremen (Germany)
  4. MohammedU New Member

    You have limited resource to resolve MSDTC issues...

    Good to know you resolved your issue...

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page