Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


share|improve this question
up vote 0 down vote accepted

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.