SUMMARY
This article discusses how to change the network IP
addresses of SQL Server virtual servers.
If you are using SQL Server 2005, see the "How to: Change the IP Address of a SQL Server 2005 Failover Cluster" topic in SQL Server Books Online.
back to the topChange the IP addresses of SQL Server 7.0 virtual servers
If you must change the IP address of your existing SQL Server 7.0
virtual server, Microsoft recommends that you uncluster SQL Server by using the
SQL Server Cluster Wizard. You can use the SQL Server Cluster Wizard to remove
the virtual server. You can then use the SQL Server Cluster Wizard to cluster
SQL Server again with the new IP address.
Note The SQL Server virtual server will be offline and unavailable
until you uncluster the virtual server, change the IP address, and then cluster
the virtual server again.
If you change any other IP addresses in the
cluster or you change the domain where the cluster resides, complete that
process before you cluster the server again.
Because of improved
functionality and recoverability in SQL Server 2000, Microsoft recommends that
you upgrade all clustered SQL Server 6.5 and SQL Server 7.0 servers to SQL
Server 2000. You may not be able to perform a SQL Server cluster upgrade on a
computer that has a previous application running as a production environment
with the SQL Server cluster. For more information and assistance, contact your
application vendor.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
274446
Upgrade to SQL Server 2000 failover solution recommended for all non-SQL Server 2000 virtual servers
back to the
topChange the IP addresses of SQL Server 2000 virtual servers
If you must change the IP address of your existing SQL Server 2000
virtual server, whether it is a default instance or a named instance, you can
use the
Advanced\Maintain Virtual Server for Failover
Clustering option in the SQL Server 2000 Setup program.
To
use the
Advanced\Maintain Virtual Server for Failover
Clustering option, follow these steps:
- Insert the SQL Server 2000 Enterprise Edition CD, and then
click SQL Server 2000 Components.
- Click Install Database Server.
- On the Welcome screen, click
Next.
- Type the name of the virtual server that you want to
modify, and then click Next.
- Click the Advanced options tab, and then
click Next.
- Click Maintain a Virtual Server for Failover
Clustering, and then click Next.
- In the Failover Clustering dialog box,
you can:
- Add an IP address for additional networks.
- Remove and replace an existing IP address.
- Remove IP addresses that you do not need.
After you make these changes, click Add,
and then click Next.
Note Assign only one IP address for each network and one network for
each network adapter. SQL
Server requires that each IP address that is assigned to it have its own unique subnet
mask. SQL Server does not support multiple IP addresses on the same subnet because this may result in duplicated names on the network. For
example, if you have a public network and a private network and you want to
assign an additional IP address to your SQL Server virtual server, you must add
another network adapter to each node to create a new network. You can then
assign the additional IP address to the new network. - Make any changes to the nodes, and then click
Next.
- Verify the requested user information and password, and
then click Next.
To verify that the changes were
made, see the SQL Server 2000 IP resource properties in Cluster Administrator
for the virtual server. - Click Finish.
Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows registry
If the subnet mask for the resources in Windows cluster is changed, the steps that are mentioned earlier cannot be used to change the IP Address of a SQL Server Virtual Server.
Change the IP address when the subnet mask for the resources in a Windows cluster is changed
If you change the subnet mask for the resources in a Windows cluster, and there is only one network adapter for the public network on each node in the cluster, you may not be able to use the SQL Server 2000 Setup program to change
the IP address of a SQL Server virtual server. When you change the subnet mask for the resources in a Windows cluster, the subnet mask of the network card and the public network also changes. Therefore, the SQL Server resources do not come online because the subnet mask for the SQL Server virtual server and the SQL Server IP address resources are
obtained from the Microsoft Cluster Service. If the
SQL Server resources are offline, you cannot use the Setup program to change
the IP address of a SQL Server virtual server.
If the subnet mask for the resources in a Windows cluster is changed, follow these steps to
change the IP address of SQL Server virtual server:
- Open Cluster Administrator.
- In the left pane, expand the Windows cluster name, expand Cluster Configuration, and then click Networks.
- In the right pane, verify that the public network has the
new subnet mask.
- In the left pane, expand Groups, and then click Resources.
- Right-click the SQL Server IP Address resource name, and then click Properties.
- Click the Parameters tab.
- In the Address box, type a new IP address.
- In the Subnet mask box, type the new subnet mask.
- In the Network box, click the public network that has the new subnet mask.
- Bring the SQL Server IP Address resource online. You may notice that the SQL Server IP address resource and the Network name resource come online.
To make sure that the SQL Server IP address is changed, follow these steps:
- Check the SQL Server IP Address resource by right-clicking the resource, clicking Properties, and then clicking the Parameters tab. The IP address and the subnet mask should be displayed. Click Cancel.
- Check the SQL Server error log to make sure that the instance of SQL Server is listening on
the new IP address on the designated port.
Warning SQL Mail is not fully supported when it is used with SQL Server
2000 failover clustering because MAPI is not cluster-aware. When SQL Mail is
used on a failover cluster, Microsoft makes commercially reasonable efforts to
provide support but cannot guarantee stability or availability.
Microsoft has confirmed that this is a problem in SQL
Server 6.5, 7.0, and 2000 when SQL Mail is used on a failover
cluster.
back to the
top