Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Multiple IP's (from 2 different networks) on a single SQL ..

 
   Database Forums (Home) -> Clustering RSS
Next:  "Hands on training" requirement for lat..  
Author Message
chrismk

External


Since: Dec 06, 2007
Posts: 1



(Msg. 1) Posted: Thu Dec 06, 2007 9:58 am
Post subject: Multiple IP's (from 2 different networks) on a single SQL 2005 Cluster
Archived from groups: microsoft>public>sqlserver>clustering (more info?)

Hello there,

I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have three NIC's in each server.

Each NIC is connected to a different network:

192.168.100.1 is the public NIC

10.0.0.1 is the NIC used for communication betwen the cluster nodes (heartbeat)

192.168.200.1 is the admin NIC

I have installed my cluster using the 192.168.100.0 network for public access. This means that my SQL virtual ip is 192.168.100.10

Each server can be administered over the 192.168.200.0 network (admin) and the cluster/sql sever ip is available from the 192.168.100.0 (public) network.

Now for my question: How can I assign a ip address from my admin network (e.g.192.168.200.10) to the existing SQL server cluster to make it available from my admin network while keeping the public ip.

Thanx in advance!



Chris



From http://www.developmentnow.com/g/99_2004_12_1_0_0/sql-server-clustering.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

 >> Stay informed about: Multiple IP's (from 2 different networks) on a single SQL .. 
Back to top
Login to vote
Russ Kaufmann [MVP]

External


Since: Jul 12, 2006
Posts: 30



(Msg. 2) Posted: Thu Dec 06, 2007 9:58 am
Post subject: Re: Multiple IP's (from 2 different networks) on a single SQL 2005 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"chrismk" <Multiple IP's (from 2 different networks) on a single SQL 2005
Cluster> wrote in message

> I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I
> have three NIC's in each server.

BTW, I am not trying to be a pain, but some of the issues here have me
extremely curious. First, why are you putting it in the perimeter network?
You should have it behind the internal firewall so the data is fully
protected and have anything that runs in the perimeter network to make its
calls through the internal firewall using a non-standard port. Data needs to
be protected.

> Each NIC is connected to a different network:
> 192.168.100.1 is the public NIC
> 10.0.0.1 is the NIC used for communication betwen the cluster nodes
> (heartbeat)
> 192.168.200.1 is the admin NIC

Why do you need an admin NIC. There is this concept of IP routing that
should make this requirement go away. <G>

> I have installed my cluster using the 192.168.100.0 network for public
> access. This means that my SQL virtual ip is 192.168.100.10
>
> Each server can be administered over the 192.168.200.0 network (admin) and
> the cluster/sql sever ip is available from the 192.168.100.0 (public)
> network.
>
> Now for my question: How can I assign a ip address from my admin network
> (e.g.192.168.200.10) to the existing SQL server cluster to make it
> available from my admin network while keeping the public ip.

It should work. Add the new IP Address resource and set the dependencies on
all the other resources as needed.

However, just because it should work does not mean it is your best
alternative.

--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp classes are:
Dec 10 - 13 in Denver
Jan 18 - 31 in Denver

 >> Stay informed about: Multiple IP's (from 2 different networks) on a single SQL .. 
Back to top
Login to vote
Tom Moreau

External


Since: Apr 21, 2004
Posts: 441



(Msg. 3) Posted: Thu Dec 06, 2007 9:58 am
Post subject: Re: Multiple IP's (from 2 different networks) on a single SQL 2005 Cluster [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Check out the following KB articles:

http://msdn2.microsoft.com/en-us/library/ms190460.aspx
http://msdn2.microsoft.com/en-us/library/ms177447.aspx

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"chrismk" <Multiple IP's (from 2 different networks) on a single SQL 2005
Cluster> wrote in message

Hello there,

I'm currently building up a SQL 2005 Active/Standby cluster in a DMZ. I have
three NIC's in each server.

Each NIC is connected to a different network:

192.168.100.1 is the public NIC

10.0.0.1 is the NIC used for communication betwen the cluster nodes
(heartbeat)

192.168.200.1 is the admin NIC

I have installed my cluster using the 192.168.100.0 network for public
access. This means that my SQL virtual ip is 192.168.100.10

Each server can be administered over the 192.168.200.0 network (admin) and
the cluster/sql sever ip is available from the 192.168.100.0 (public)
network.

Now for my question: How can I assign a ip address from my admin network
(e.g.192.168.200.10) to the existing SQL server cluster to make it
available from my admin network while keeping the public ip.

Thanx in advance!



Chris



From
http://www.developmentnow.com/g/99_2004_12_1_0_0/sql-server-clustering.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
 >> Stay informed about: Multiple IP's (from 2 different networks) on a single SQL .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Single node cluster with multiple instances but all as def.. - Hi, I am trying to install multiple SQL 2005 instances onto one machine, which has been configured as a single node cluster. Multiple virtual servers have been created, and I am trying to install one instance onto each virtual server set up for SQL....

How many networks does clustering need ? - I know there is a public network for all application communication and one for hearbeat . Are there any more ? Does one connect the hearbeat network to like a local hub for the nodes or to the same public network ( dont know if im stating this right) ?...

Single Storage - Hi, Is it possible to use a single storage with multiple SQL Servers?? Regards Ahmad Zia

single node cluster? - Hi, Is it possible to create a single node cluster? I want to have some test for sql cluster, but I only have 1 computer available. a 2nd HD is installed on the computer, i want to use it for quorum, is it feasible? Thanks, Jack

Single Database Failover - Is it possible to set up SQL Server clustering so that only one database would failover or is it an all or nothing type thing.
   Database Forums (Home) -> Clustering All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]