dbTalk Databases Forums  

Distributed Transaction Coordinator/Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Distributed Transaction Coordinator/Cluster in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
len
 
Posts: n/a

Default Distributed Transaction Coordinator/Cluster - 02-03-2005 , 11:37 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......

Any help would be appreciated - I'm a bit worried about this stuff!

Reply With Quote
  #2  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: Distributed Transaction Coordinator/Cluster - 02-03-2005 , 07:50 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

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

Quote:
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......

Any help would be appreciated - I'm a bit worried about this stuff!



Reply With Quote
  #3  
Old   
len
 
Posts: n/a

Default Re: Distributed Transaction Coordinator/Cluster - 02-04-2005 , 04:37 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!



"Rodney R. Fournier [MVP]" wrote:

Quote:
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

"len" <len (AT) discussions (DOT) microsoft.com> wrote in message
news1696F91-B3EF-485F-A362-785E910D02D7 (AT) microsoft (DOT) com...
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......

Any help would be appreciated - I'm a bit worried about this stuff!




Reply With Quote
  #4  
Old   
Rodney R. Fournier [MVP]
 
Posts: n/a

Default Re: Distributed Transaction Coordinator/Cluster - 02-04-2005 , 06:38 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

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

Quote:
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!



"Rodney R. Fournier [MVP]" wrote:

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

"len" <len (AT) discussions (DOT) microsoft.com> wrote in message
news1696F91-B3EF-485F-A362-785E910D02D7 (AT) microsoft (DOT) com...
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......

Any help would be appreciated - I'm a bit worried about this stuff!






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.