Multiple SQL Network Name, SQL IP addresses for SQL 2000 c..

Hi All,



We are trying to migrate all databases from ABCSQL01, ASDSQL and zxcSQL
servers to ABCSQL02 server (Cluster virtual name

for nodes ABCSQL02A, ABCSQL02B)

All are SQL 2000 servers.

Here are IP addresses (Used letters instead of numbers.)
Assume each letter correspond to one digit.


ABCSQL01 -- QWE.AS.ZX.CD



ASDSQL – QWE.AS.H.JK



zxcSQL – QWE.AS.TY.UI




ABCSQL02 – QWE.AS.ZX.DF





As we don’t have enough information relating to applications which uses DB’s
on those 3 servers, we trying to find

alternative ways for smooth/transparent migration.



Some one suggested to add new SQL Network Name, SQL IP address corresponding
to those 3 servers that are going to be migrated

on ABCSQL02 cluster resource group, applications will work with out any
issues after migration of all db’s to ABCsql02. (That

means no change of connection strings.)



In Microsoft site, it is mentioned that all new IP addresses should be on
different subnet.

Can we add 3 different subnets to ABCSQL02?

If we do that what are the issues relating to network, firewall?

Is this best practice having different network subnets for same server?



Even though cleaner way of doing is migrate db’s to new server and change
connection strings , we are just trying to find out

if there is any other alternative way for transparent migration.



Any kind of help is greatly appreciated.



Here is info. from Microsoft site.



http://www.microsoft.com/technet/zxctechnol/sql/2000/maintain/failclus.mspx



SQL Server 2000 supports multiple network addresses. This enables SQL Server
2000 to listen on multiple IP addresses on

different subnets.



http://support.microsoft.com/kb/244980



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.


Regards
Kumar