MS DTC on Windows Cluster 2003

Posted on 2009-04-28
Medium Priority
Last Modified: 2012-05-06
Hi Guys,
I have a windows 2003 R2 Sp2 / 2 node cluster which i inherited from previous Sys Admin.
One node is a web server (IIS) and the other is a file server.
i can see a DTC Resource on it in one of the groups.

When the group fails to the other node....all is good.
but when it tries to fail back to the original node it fails...and causing the group to move again then staying on the other node.

my questions:
1. is MS DTC required ? (i thought it is only for SQL)
2. Why is it failing?
3. can i somehow clean all the DTC configuration in a asafe manner and recreate it?


Question by:fleetcare
  • 2
  • 2
LVL 26

Expert Comment

ID: 24260001
Generally the DTC is used for SQL but I've seen other types of cluster resources require it.  Best practice would be to have the DTC in its own resource group independant of your groups.
To try and answer some of your questions:
1)  Hard to tell since you inherited from the previous sysadmin.   Tt may be best to find our what the web server or file server are doing.  It may be possible, but without knowing your environment/applications it would be impossible to predict this.  You could disable it for a period of time and see if there are ill effects.
2)  Once again hard to determine why it is failing.  This link might help, but without know why msdtc is running, it may be difficult:  http://msdn.microsoft.com/en-us/library/aa561924.aspx
3)   You should.  We've done this serveral times on some of our misconfigured clusters to make them right.  Use the steps in here to move the msdtc to its own cluster group.  http://support.microsoft.com/kb/243204/en-us - refers to 2000, but steps are still valid in 2003.  Now if the dtc files, it won't take down your other resource groups.
See this as well:  

Author Comment

ID: 24266433
Hi Pber,
Thank you for your information.
The DTC resource is not in its own group. it is in a group with
Disk Q / Cluster Name / Cluster IP Address resources.

Does the DTC resource exist on the cluster to make the failover to the other node successful (maybe iis transactions)?
I know the Web server is querying a SQL Server which is not part of the Web Cluster...

If i remove the DTC from the cluster, can something serious happen when it fails to the other node?

LVL 26

Accepted Solution

Pber earned 2000 total points
ID: 24269136
Once again, without knowing your environment, it's tough to tell why DTC is on the cluster.  The DTC is usually grouped with the SQL server clusters.  It is possible that the web service is using a COM+ or a .Net component that uses it.
The DTC is used to coordinate SQL type transactions from data involving several sources/targets to ensure the transaction is reliable.   See this:  http://itknowledgeexchange.techtarget.com/sql-server/what-exactly-is-msdtc-any-when-do-i-need-it/
You could just try and keep the resource offline and see if it affects your web services.  You are probably best just re-building the MSDTC on the cluster from scratch.

Author Closing Comment

ID: 31575342
Thanks Pber for all the Information.
I think like you mentioned...it is best to rebuild the DTC on the cluster from scratch.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
Wow it feels like forever since I have been able to sit down and write an article, I have been away and new exciting projects keeping me busy, but here I am writing another hopefully informative article. I have written about Orchestrator 2012 int…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question