January 7, 2009 at 9:50 am
i have created windows clustering with two node .
after that i have installed the MSDTC in the server .but it was not starting after that i have created MSDTC Group with reference of ip address,physical ,dtc ... in the cluster .Then its was starting. After some days i have decided to remove one node from the cluster group for some reason , so i evict the node one which was in passive state. but MSDTC is not able start on the server . Please give your suggestion to bring up the MSDTC .
Error Description:
1)Could not start the MS DTC Transaction Manager.
2)MS DTC Transaction Manager start failed. LogInit returned error 0x3.
3) MS DTC log file not found. After ensuring that all Resource Managers coordinated by MS DTC have no indoubt transactions, please run msdtc -resetlog to create the log file.
January 7, 2009 at 11:09 am
Have you tried running msdtc -resetlog ?
January 7, 2009 at 12:35 pm
Nicholas Cain (1/7/2009)
Have you tried running msdtc -resetlog ?
yes ..i tried but it is not resolving this problem...
January 7, 2009 at 12:47 pm
Is there anything in the windows event logs?
Could you also post the cluster log
January 7, 2009 at 12:56 pm
Nicholas Cain (1/7/2009)
Is there anything in the windows event logs?Could you also post the cluster log
from error log
1)Could not start the MS DTC Transaction Manager.
2)MS DTC Transaction Manager start failed. LogInit returned error 0x3.
3) MS DTC log file not found. After ensuring that all Resource Managers coordinated by MS DTC have no indoubt transactions, please run msdtc -resetlog to create the log file.
January 7, 2009 at 1:13 pm
Not from the SQL Server error log, the Windows System and Application logs. Also the cluster.log
January 7, 2009 at 2:57 pm
We have had a similar issue with MSDTC on a two node cluster with SQL 2000. To get it to work, sometimes it has been as easy as just moving the MSDTC Resource within the Cluster from One Node to the Other. There have been other times that we have had to reinstall MSDTC on the cluster (which really easy to do, just using the command prompt "Msdtc –install") and other times we have had to reboot the individual nodes on the cluster and then reinstall MSDTC. We have found it to be incredibly flaky but usually some combination of those things has been adequate. Obviously the first two options are better since you do not have to take SQL down in order for them to work, but there have been times when that was necessary for us as well.
January 9, 2009 at 12:42 am
Thanks for urs reply ... i had uninstalled the msdtc and installed again , now its working fine..
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply