Groups | Blog | Home
all groups > sql server clustering > february 2005 >

sql server clustering : Distributed Transaction Coordinator/Cluster


len
2/3/2005 9:37:06 AM
Hi there. I'm new to this clustering mularky and I've a couple of questions
regarding a linked-server query I have.

1. Server A is a regular server. Server B is a clustered server with shared
storage.
From A, I want to call a stored proc that sits on B.
Q: I need to add B(cluster) as a Linked server on A - Do I need to add A as
a linked server on B also?


2. Depending on the answer to my first question, I might need to get MSDTC
running on the clustered server - is there some special configuration I
should undergo? I've come across some msdn articles regarding use of
"Comclust.exe" but I don't know if I need to use it......

Rodney R. Fournier [MVP]
2/3/2005 7:50:08 PM
I can answer #2 - Follow 817064, then 301600 :)

Cheers,

Rod

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

[quoted text, click to view]

len
2/4/2005 2:37:03 AM
Dhanks for that - it's just what I was looking for! I have one question
regarding 301600 though:

Part of the instructions state that after creating a Cluster group for
MSDTC, I need to add an IP Address resource to that group.

What I don't know is: where should this IP address come from? I've already
tried the IP address of both of my cluster nodes AND the virtual IPAddress of
my shared storage/SQL server but errors are thrown up about these being in
use already. do I need to create an entirely ne IP address?

thanks again!



[quoted text, click to view]
Rodney R. Fournier [MVP]
2/4/2005 6:38:08 AM
You are most welcome.

The IP has to be a new IP address, it needs to be in the same subnet as the
SQL & Cluster IP.

Cheers,

Rod

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

[quoted text, click to view]

AddThis Social Bookmark Button