How to: Change the IP Address of a SQL Server Failover Cluster

SQL Server Setup

To maintain or update a SQL Server failover cluster, use Add or Remove Programs in Control Panel. For information about command prompt syntax, see How to: Install SQL Server 2008 from the Command Prompt.

Before you begin, review the following SQL Server Books Online topic: Before Installing Failover Clustering.

For additional information about changing the IP address of network adapters in the nodes of a cluster, see this Microsoft Knowledge Base article.

Important:
To maintain or update a SQL Server failover cluster, you must be a local administrator with permission to logon as a service on all nodes of the failover cluster.

To change the IP address of an existing SQL Server failover cluster

  1. From the Start menu, click Run, and then type cluadmin . to launch the Cluster Administrator and connect to the local instance.

  2. In the left-hand pane, expand the Group node and select the Group to be updated.

  3. In the right-hand pane, right-click the SQL IP Address1(failover cluster instance name) and select Properties.

  4. Click the Parameters tab, and then update the IP address for SQL IP Address1(SQL Server Name) in the Address field.

  5. Click Apply to implement the change. You may see a warning dialog that says:

    "Cluster Administrator Standard Extension: An error occurred attempting to set properties: The properties were stored but not all changes will take effect until the next time the resource is brought online. Error ID: 5024 (000013a0)."

  6. Click OK to clear the Cluster Administrator Standard Extension dialog, and you will be returned to the Cluster Administrator. To take resources offline and then put them back online, use the following steps.

  7. In the right-hand pane, right-click the SQL IP Address1(failover cluster instance name) and select Take Offline. You will see the SQL IP Address1(failover cluster instance name), SQL Network Name(failover cluster instance name), and SQL Server status change from Online to Offline Pending, and then to Offline.

    Note:
    It may take 30 minutes or more for IP changes to propagate through a corporate network. You should try to bring the SQL IP Address 1(failover cluster instance name) and the SQL Network Name(failover cluster instance name) online, then try to ping the failover cluster instance name and wait for it to be resolved by the DNS to the new IP address.

  8. In the right-hand pane, right-click SQL Server, and then select Bring Online. You will see the SQL IP Address1(failover cluster instance name), SQL Network Name(failover cluster instance name), and SQL Server status change from Offline to Online Pending, and then to Online.

  9. Close Cluster Administrator.

See Also