Re: Cluster IP Address change

Doesn't sound like it, but you're the third person in the last three weeks
I've heard the same story from...after not hearing this in 2 years of SQL
cluster support...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm




"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:646AFA80-DC17-4137-87E0-9BBA9FB68399@xxxxxxxxxxxxxxxx
Here my experences of changing sql virtual server ip address
I ran the setup program to change the ip address while resources were
offline.
After changing sql ip address resource & sql name resource came online but
sql server resource was failing. When i checked sql errorlog it showed
error
unable to bind ip address.
I checked the registry, it was showing old ip address. I manually changed
the registry to new ip address after which the sql server came online
successfully.

i am not able to understand what went wrong which resulted me in changing
registry.

did i miss out any step.

thanks,

sats

"Rodney R. Fournier [MVP]" wrote:

You can't change the parameters of any resource while it is running, it
always requires a restart of the resource to take affect.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F68A4B9-62D3-44B9-A437-418DEC201434@xxxxxxxxxxxxxxxx
But article
http://support.microsoft.com/default.aspx?scid=kb;[LN];244980
does not mention to bring any resources offline to do ip address
change.
What you said is from your praticle experiences

Sorry for all these questions, never done this change so making sure i
am
ready with all steps.
Thanks
Satwinder

"Tom Moreau" wrote:

You have to take SQL Server offline before you can change the IP.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EB85D323-5B73-496D-928B-A09ACF8AD89A@xxxxxxxxxxxxxxxx
To be able to change sql virtual ip address, should sql server running
&
sql
server resources online in cluster administration.

"Rodney R. Fournier [MVP]" wrote:

Really does not matter, but I always move it, then change the IP.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6162295D-19CE-4E88-87CC-FAB3E113B82A@xxxxxxxxxxxxxxxx
Hi,
My server is moving from 1 location to another. When to change the
sql
virtual server ip address:
1. change ip address shutdown the server and move it
2. Move the server to new location into network and then change
the
ip
address.
Which option is recommanded.

To run sql server installation for changing ip address, has sql
server
running and its resource online in cluster service.

Thanks..
"Satwinder" wrote:

Thanks all for your valuable replies. i will keep you posted
onces
in
do
the
ip address change.

"Rodney R. Fournier [MVP]" wrote:

17 times or so. We build our clusters locally and ship to the
center,
then
have to change the IPs. Works great. No worries!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:41CE5769-8ABC-4B3E-B072-D16BDF4631B4@xxxxxxxxxxxxxxxx
Thanks to all of you. I have already seen that KB. Have
anyone
done
this.
If
yes any observations.

Satwinder...
"Russ Kaufmann [MVP]" wrote:

"Rodney R. Fournier [MVP]" <rod@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
wrote
in
message news:eXuy4I4qGHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
Have you looked at
http://support.microsoft.com/kb/244980/en-us
yet?

I was about 5 hours ahead of you on that one. <G>


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
















.

Relevant Pages