![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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! |
#3
| |||
| |||
|
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 news 1696F91-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! |
#4
| |||
| |||
|
|
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 news 1696F91-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! |
![]() |
| Thread Tools | |
| Display Modes | |
| |