Re: Cluster IP Address change

Tech-Archive recommends: Speed Up your PC by fixing your registry

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: Cluster IP Address change
    ... You can't change the parameters of any resource while it is running, ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: 4 Queries about DB clustering
    ... Server clustering is available on Windows Server 2003 Enterprise Edition. ... "Single Data Store" is not a service, ... I support the Professional Association for SQL Server ...
    (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)