Tuesday, February 14, 2012

Distributed Transaction Coordinator/Cluster

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!
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@.discussions.microsoft.com> wrote in message
news:D1696F91-B3EF-485F-A362-785E910D02D7@.microsoft.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!
|||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@.discussions.microsoft.com> wrote in message
> news:D1696F91-B3EF-485F-A362-785E910D02D7@.microsoft.com...
>
>
|||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@.discussions.microsoft.com> wrote in message
news:08F90F15-972F-41D6-87E1-F34C1EBCFAB3@.microsoft.com...[vbcol=seagreen]
> 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:

No comments:

Post a Comment