Home / server / Questions / 175401
Accepted
I.T. Support
Asked: 2010-08-28 10:54:34 +0800 CST

Move clustered SQL from one network to another

  • 772

We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway issues with the servers being multi-homed.

My question is what is the best way to migrate the SQL cluster from one network to the other? It would reside in the same cluster, same name, just dependent on another subnet.

My instinct tells me to just reinstall sql into the cluster, specifying the other subnet on the install, then clean up the mess afterwards.

But I was wondering if maybe there was any other ways, perhaps a best practice that I'm not aware of.

Thanks

sql-server sql-server-2005 windows-server-2003 cluster

1 Answers

  1. Best Answer

    To resolve this we simply configured SQL Server to accept conenctions on the new subnet, then configured it not to accept connections on the old subnet.

    • 0