Re: Cluster IP Address change

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

  • Re: Newb Active-Passive / Active-Active Single Instance Question
    ... The Disk space is SAN storage. ... node and one virtual server. ... cluster node as it is no longer like Windows Clustering is it that SQL 2005 ... Also, SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using sql server clustering
    ... Clustering will give that one high availability. ... other 4 can still handle the load while you fix the one that is down. ... add more server for incoming data wich is failover cluster. ... About the servers to pull data, can i use sql server clustering in order ...
    (microsoft.public.sqlserver.clustering)
  • Re: So exactly what IS clustering?
    ... I'd go with .server and .programming for this type of question. ... Edition of SQL Server. ... There's clustering and then there's clustering. ... So I've just run the index tuning wizard over ...
    (microsoft.public.sqlserver.clustering)
  • Re: Memory Allocation - Win2k3 SP1 and SQL Server 2K SP4
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • HA & Failover options
    ... instances for all the technology components (App Server, DB Server, ... Application Server 10g Release 3 and Oracle Database Release 2. ... Clustering features. ... how instantaneous is failover to the secondary site with data ...
    (comp.databases.oracle.server)