Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

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

 
discard

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.