Cluster IP Address change

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Satwinder - 19 Jul 2006 14:49 GMT

What are the step to be followed change the SQL Server Virtual IP address.
SQL Server 2000 Enterprise version with SP3
Windows Server 2003 Enterprise Edition

Reply to this Message

Kalyan Yella - 19 Jul 2006 16:49 GMT

Re-run SQL Server setup and choose the option to modify exisitng
installation. You can remove the exisitng IP and add a new IP.

> What are the step to be followed change the SQL Server Virtual IP address.
> SQL Server 2000 Enterprise version with SP3
> Windows Server 2003 Enterprise Edition

Reply to this Message

Russ Kaufmann [MVP] - 19 Jul 2006 18:11 GMT

> What are the step to be followed change the SQL Server Virtual IP address.
> SQL Server 2000 Enterprise version with SP3
> Windows Server 2003 Enterprise Edition

How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/?id=244980

Signature

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

Reply to this Message

Rodney R. Fournier [MVP] - 19 Jul 2006 23:25 GMT

Have you looked at http://support.microsoft.com/kb/244980/en-us yet?

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

> What are the step to be followed change the SQL Server Virtual IP address.
> SQL Server 2000 Enterprise version with SP3
> Windows Server 2003 Enterprise Edition

Reply to this Message

Russ Kaufmann [MVP] - 19 Jul 2006 23:43 GMT

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

Signature

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

Reply to this Message

Satwinder - 20 Jul 2006 06:26 GMT

Thanks to all of you. I have already seen that KB. Have anyone done this. If
yes any observations.

Satwinder...

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

Reply to this Message

Rodney R. Fournier [MVP] - 20 Jul 2006 13:00 GMT

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

> Thanks to all of you. I have already seen that KB. Have anyone done this.
> If
[quoted text clipped - 5 lines]
>>
>> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Satwinder - 22 Jul 2006 07:36 GMT

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

> 17 times or so. We build our clusters locally and ship to the center, then
> have to change the IPs. Works great. No worries!
[quoted text clipped - 18 lines]
> >>
> >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Satwinder - 13 Sep 2006 14:31 GMT

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

> Thanks all for your valuable replies. i will keep you posted onces in do the
> ip address change.
[quoted text clipped - 21 lines]
> > >>
> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Rodney R. Fournier [MVP] - 13 Sep 2006 15:31 GMT

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

> Hi,
> My server is moving from 1 location to another. When to change the sql
[quoted text clipped - 38 lines]
>> > >>
>> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Satwinder - 14 Sep 2006 05:54 GMT

To be able to change sql virtual ip address, should sql server running & sql
server resources online in cluster administration.

> Really does not matter, but I always move it, then change the IP.
>
[quoted text clipped - 50 lines]
> >> > >>
> >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Tom Moreau - 14 Sep 2006 11:42 GMT

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

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
.

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.
>
[quoted text clipped - 57 lines]
> >> > >>
> >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Satwinder - 14 Sep 2006 16:19 GMT

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

> You have to take SQL Server offline before you can change the IP.
>
[quoted text clipped - 64 lines]
> > >> > >>
> > >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Rodney R. Fournier [MVP] - 14 Sep 2006 16:24 GMT

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

> 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.
[quoted text clipped - 82 lines]
>> > >> > >>
>> > >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Satwinder - 23 Sep 2006 04:51 GMT

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

> You can't change the parameters of any resource while it is running, it
> always requires a restart of the resource to take affect.
[quoted text clipped - 95 lines]
> >> > >> > >>
> >> > >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message

Kevin3NF - 23 Sep 2006 17:02 GMT

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

Signature

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

> Here my experences of changing sql virtual server ip address
> I ran the setup program to change the ip address while resources were
[quoted text clipped - 125 lines]
>> >> > >> > >>
>> >> > >> > >> I was about 5 hours ahead of you on that one. <G>

Reply to this Message