We have an active/active SQL 2005/Windows 2008 2 node cluster that has 1
instance running on node 1 and 1 instance running on node 2.

Our DBA wants me to add a clustered DTC resource for each instance.

2 ways I am trying to do this and each presents a problem.
First way:
Right click Services and Applications
Configure service or application
Distributed Transaction Coordinator
Give it a network name and an IP
No storage is available
Why? I want to assign this to the same disk that the SQL logs are on.

Second way:
Right click one of the instances
Add a resource
Distributed Transaction Coordinator
It creates an offline resource for it but I dont see anyway to set the
network name, IP, or configure for high availability like the wizard above.

Of course finding a guide on how to do this has been fruitless as usual.

Anyone have any ideas?
Only thing I can think of is creating another group, presenting a new
drive to the cluster, adding it to that group and then running the
Wizard. Once added, then moving it to one of the instances and changing
the drive it depends on. Which all seems like a huge, unnecessary hassle.

Thanks in advance.

Hi JJP,

The following microsoft article may help you
http://support.microsoft.com/kb/301600/

Regards, Balaji

"JJP" <anonymous (AT) microsoft (DOT) com> wrote

Hi, thanks but that article is for Windows 2003 cluster.
Mine is Windows 2008 and therefore pretty different.
Seems no one on this group knows, so I will have to figure something out
myself. Ok, thanks.



Balaji wrote: