Hi GUYS,
I am setting up a sql cluster on win 2003.
i am using distributed transaction so using MSDTC.
as far as i know WHILE Clustering MSDTC we have to give a
unique ip address to the msdtc resource, is this ip
address shold be same as cluster ip adrress or a seperate
ip address.



for eg: for sql virtual server i am using 170.2.30.1 range
and for back to back (private connection) 10.1.1.1

in this case which range i should choce for MSDTC.

HOW SQL SERVER virtual adress is linked to MSDTC Address.

pls Advice me.

You can give it a dedicated IP address or share the cluster one. Best
practices around MSDTC keep changing, you may not need MSDTC at all on a SQL
Cluster, if you application does not use it.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog

"bijupg" <anonymous (AT) discussions (DOT) microsoft.com> wrote

If MSDTC is used exclusively for SQL, should you use the cluster IP or
the SQL IP?

Thanks,

Jeff Allred

Rodney R. Fournier [MVP] wrote:

I would use a dedicated disk resource for sure, the IP & Name are up to you.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog

"Jeff Allred" <6stringcowboy (AT) bellsouth (DOT) net> wrote

Rodney,
We are using an application that utilizes linked servers on our
clustered databases and therefore must have the MSDTC installed/clustered.
We have already set up one environment on Windows 2003 server (Active /
Passive cluster) with SQL Server 2000 sp3a with the MSDTC cluster sharing the
IP address and shared storage area of the QUORUM. I know the ideal
installation is to have a separate IP address and its own shared storage
space. Are there any known problems with the current configuration of having
the MSDTC cluster share the QUORUM cluster group?

thanks in advance,
Doug
"Rodney R. Fournier [MVP]" wrote:

Only if you let a MSDTC failure take the group down. Its not a best practice
for SQL, but it works nicely.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog

"Doug Binger" <Doug Binger (AT) discussions (DOT) microsoft.com> wrote