Changing Physical IP Addresses - SQL Server 2005 Cluster

  • Hi All,

    As per application upgradation/design, we're suppose to change the physical IP of the nodes for an Active/Passive cluster.

    The I.P. address changes will be for physical nodes only, not for any virtual I.P.

    Will any changes need to be done on cluster administrator or any other settings.

    Regards,

    Vikas Nigam

  • thelegendarywolf (4/9/2012)


    Hi All,

    As per application upgradation/design, we're suppose to change the physical IP of the nodes for an Active/Passive cluster.

    Why?

    thelegendarywolf (4/9/2012)


    The I.P. address changes will be for physical nodes only, not for any virtual I.P.

    Will any changes need to be done on cluster administrator or any other settings.

    Regards,

    Vikas Nigam

    You may want to check there are no firewall rules for the current node IPs

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I believe that the answer is no. As I understand it any changes at that level involve rebuilding the SQL Server cluster. To be sure I would contact Microsoft for verification.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • I would give a quick support call to Microsoft, but I don't believe changing the IP addresses for the physical nodes is an issue. If you're going to change the IP for a virtual node, that requires re-running SQL Server setup. You don't want to change the IP through cluster administration, though it looks like you can. SQL Server won't pick up the correct IP. However, physical node IP shouldn't matter. With all that said, a $250 to confirm you won't have an issue is a small price to pay.

    K. Brian Kelley
    @kbriankelley

  • Changing the SQL Virtual IP address is actually relatively easy, but does require down time. See this KB http://support.microsoft.com/kb/244980

    I can't see any reason why the application should require you to change the node IP addresses, this doesn't make sense unless the application is very poorly designed, or worse is running on the node and using the IP address to control licenses (I have seen this). An application talking to a SQL Cluster shouldn't have any knowledge of the node IP addresses, and I would ask the vender for a very detailed justification for changing the node IPs.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply