Problem with MS DTC | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Problem with MS DTC

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

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

]]>