January 13, 2006 at 10:11 am
Does anyone know how DTC works on SQL cluster? I installed SQL 2k ENT on the clustered Windows 2003, installed Oracle client on the two nodes, created the linked server to connect to Oracle, then tested application, did the fail-over testing as well. It works fine. Then I realize that DTC is required for clustering SQL, we enabled DTC to access the network, created resource on Cluster for DTC. I tested application again, it can not connection to the SQL cluster anymore and show the page can not be displayed. Any idea?
January 13, 2006 at 3:25 pm
What service pack (operating system) are you on? Also, have you configured DTC for network access?
K. Brian Kelley
@kbriankelley
January 15, 2006 at 8:51 pm
We have had add behavior with DTC in my shop too. As a matter of practice, DTC is in the same resource group as the quorum disk. When we move between nodes we always move this resource group first and then move the resource group with the sql server in it second.
It makes a difference for us but I don't think we have every seen it documented but it works.
good luck,
January 17, 2006 at 8:20 am
I will give a try to switch to Quorum disk group. To answer Brian's question, yes, we did enable Network Access. OS is window 2003, SP1.
January 17, 2006 at 10:08 am
In case you haven't seen it, this is the KB for configuring DTC on a Win2003 cluster.
http://support.microsoft.com/kb/301600/en-us
good luck
January 17, 2006 at 3:03 pm
We went back and forth with Microsoft support on this because in Windows 2000, DTC was on the quorum drive. However, the recommended configuration for Windows 2003 is for DTC to have its own drive. The reason that eventually came back is DTC has the potential to incur intensive disk access. Obviously, if this is on the quorum drive it could create a contention issue and potentially threaten the health of the cluster.
K. Brian Kelley
@kbriankelley
January 17, 2006 at 3:04 pm
So the network access was enabled after the configuration of DTC as a cluster resource (and after the application of the service pack)?
K. Brian Kelley
@kbriankelley
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply