Hi,
I have been setting up a WIN2K3 Cluster here today and having some
problems. I can get SQL Installed ok and everything works fine until I set
my Application Servers to point at the new SQL Server, at which point my
Component Services Components start getting MSDTC errors - 'New transaction
cannot enlist in the specified transaction coordinator' to be precise.

Here is what I did in order:
Installed Windows 2003 (with SP1 already preapplied)
Setup Network Connections (for internal cluster comms and public network)
Set Server to be an Application Server Role (ensuring Enable Network DTC
Access was checked)
Reboot Servers
Setup Cluster
Add second node to cluster
Reboot Servers
Install SQL
Apply SP3a to SQL
Reboot Servers
Finally I added in the MSDTC Resource (and I have tried this in the Cluster
Group and the SQL Group, and finally in its own group)
Tried to call my components and I get the above errors.

I have since gone through god knows how many web sites looking for answers
and tried all the suggested things such as ensuring MSDTC is started before
SQL Starts etc to no avail.

What I did notice is that when I actually add the MSDTC resource to the
cluster then go back into Add Remove Programs it has unchecked Enable network
DTC access (Yes it was definately checked - I checked at least 5 times and
even ended up re-installing both servers and setting it all up again to make
sure I wasn't going crazy!)

I re-checked the box on both servers and rebooted them both and still
nothing. I also checked the Registry to ensure the MSDTC Keys relating to
network transactions were both set to 1.

I have tried DTC Tester also and I get an error just after it tries to
Enlist the connection in the transaction, which is a Distributed Transaction
Error. The extra detail says Invalid Cursor State.

When I run the DTC Tester on either node of the cluster it works fine so it
HAS to be related to network DTC, but all the settings seem correct!

Please HELP!

Dan

How did you "add DTC to the cluster group"? Make sure you followed the
Win03 instructions, they are different than for Win2K.

817064 HOW TO: Enable Network DTC Access in Windows Server 2003
http://support.microsoft.com/?id=817064
301600 How to configure Microsoft Distributed Transaction Coordinator on a
http://support.microsoft.com/?id=301600

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Cindy,
I added it to the cluster group following the instructions in the article
you mention. I have previously setup a Win2k3 cluster with the same setup
(HP DL380 Packaged Cluster) and the only difference was that the other
cluster was not running SP1.

Dan

"Cindy Gross (MSFT)" wrote:

Please check the MSDTC Security.

Go on Administrative Tools, Component Services, MSDTC and MSDTC Security
Configuration.
With Win2003 SP1 the MSDTC Security changed a litte bit. There is a new Tab
called mutual authentication Required. If it is set them only computers
running Windows XP SP2 and Windows 2003 SP1 can communicate with each other.
If you need to talk with computers with other operation system versions you
should change that setting to "No authentication Required".

Below is a link with information about the changes on MSDTC Security.
http://www.microsoft.com/technet/pro.../sp2otech.mspx

Regards
--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org


"Dan Sadler" wrote: