修改sql2000服务器ip地址,SQL Server 2000故障转移群集如何更改ip地址

直接在群集管理器的sql server ip

address属性中更改后，本机连接没有问题，但其他机器和应用程序使用ip地址或服务器名都连不上，从微软网站上查到，正确方法应该是：

Change the IP addresses of SQL Server 2000 failover cluster

instances

If you must change the IP address of your existing SQL Server 2000

failover cluster instance, 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:1. Insert the SQL Server 2000

Enterprise Edition CD, and then click SQL Server 2000

Components. 2. Click Install Database Server. 3. On the Welcome screen, click Next.

4. Type the name of the failover cluster instance that you want to

modify, and then click Next. 5. Click the Advanced options tab, and then click

Next. 6. Click Maintain a Virtual Server for Failover Clustering, and

then click Next. 7. 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 failover cluster

instance, 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. 8. Make any changes to the nodes, and then click

Next. 9. 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 failover

cluster instance.

10. Click Finish.

>>

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 failover cluster instance.

然后重启相关服务就可以了。