Changing the IP for a SQL 2008 cluster default instance

Last post 01-07-2009 11:03 AM by WingSzeto. 4 replies.
Page 1 of 1 (5 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 01-02-2009 11:52 AM

    Changing the IP for a SQL 2008 cluster default instance

    After SQL cluster was setup and tested, we are ready to move to a production environment.  Say our test environment is using 192.x.x.x network, the production is using 11.x.x.x network.  Is there a way to change the IP for the SQL cluster default instance without destroying the cluster first?

     We are using two-node active passive clustering scheme. It is on Window 2008 enterpise 64 bit version and SQL 2008 is a standard 64 bit version.

     Any pointer is very much appreciated.

     Wingman

  • 01-04-2009 8:13 PM In reply to

    Re: Changing the IP for a SQL 2008 cluster default instance

    Check the following....

     

    SQL Server 2008 Books Online (December 2008)
    How to: Change the IP Address of a SQL Server Failover Cluster

    http://msdn.microsoft.com/en-us/library/ms190460.aspx

     

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  • 01-05-2009 11:16 AM In reply to

    Re: Changing the IP for a SQL 2008 cluster default instance

    Thank for the reply.

     Actually I did read about the link before I posted my question.   But I had difficult following the steps from step 2 to 5 and since it doesn't match what I see in SQL 2008 clustering admin tool, I thought it may be for SQL 2005 so I posted my question.  Anyway, on step 2, it mentioned about the 'Group Node'.  If it means the Nodes subtree in the cluster management tool, it has no IP adddress I can update.  If it means the 'Services and Applications' subtree, there is a SQL resource group I created during the SQL cluster installation and I can expand and right click the IP address under the Server Name(SQL cluster instance name) on the Right Pane.   But I don't see any Parameters tab at all as stated in step 4.  But under the general tab, there is a Static IP address field which allows me to change the IP address.  However, as for my original question which I like to change the IP address from 192.x.x.x to 11.x.x.x, it won't allow me to change from 192 to 11.   I can change the last part of the IP but not the first part.   Is there a way to do it? 

    I also want to know if the BOL steps and the link you mentioned are for SQL 2008 because if I am doing something wrong in my SQL 2008 cluster setup, I need to know it now. 

     

  • 01-07-2009 2:22 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 23,751
    • Microsoft MVP
      Moderator

    Re: Changing the IP for a SQL 2008 cluster default instance

    Have you checked whether relevant permissions are assigned to CLUSTER service & SQL SErver service accounts on this environment?

    Also while deploying the CLUADMIN tool make sure to run it as ADMINISTRATOR.

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
  • 01-07-2009 11:03 AM In reply to

    Re: Changing the IP for a SQL 2008 cluster default instance

    Yes, I did.   Just to make sure, here is what I did.  For the cluster service account, it has a local admin right and has the 'create computer object' right, and the 'publc' right to the SQL server.  These are done based on a MS article I read.    For the SQL service account, it just needs a domain user account.  Let me know if this is what you expect. 

     For the CLUAdmin, the windows account I log in to that server already has a local administrator right.  In any case, rather running CLUadmin tool as is or run it as administrator gives me the same features and menu options in the CluAdmin management console.

    When you run the CLUAdmin tool in windows 2008, are you seeing what I am seeing or you are seeing what the link and its instructions are showing?

Page 1 of 1 (5 items)
Active Topics   My Discussions    Unanswered Posts


© 2010 Jude O'Kelly All Rights Reserved.