Re: Server availability in an Active Passive Cluster

Sorry for the confusion. I currently have two SQL servers. SQL01 and
SQL02. They are currently not in a cluster. I have a number of
applications and documents that are referencing SQL01 as their data
source. When I create the Active/Passive cluster, I plan to create a
virtual server name, CXSQL.

My question is: Once the cluster is created, and SQL01 is the active
member of the cluster, if a client makes a SQL request to SQL01, will
the client get a response ?

I saw this KB doc
http://support.microsoft.com/?scid=kb;en-us;243218&spid=2852&sid=663:
SQL Server 2000 does not listen on the IP address of the local servers.
It listens only on the clustered IP addresses created during the setup
of a virtual server for SQL Server 2000.

Obviously the SQL01 and CXSQL will have different IP numbers. What this
is telling me is that once I cluster the server, I have to make sure I
go around to all of my applications and make sure they use the virtual
server name CXSQL, instead of SQL01. I was hoping for a grace period to
get all the applications changed over to the new SQL name.

I am asking this question, because with our File Server cluster, the
active server FS1, is accessible the same way as the virtual file
server name cxfs1. I realize that referencing using the FS1 name will
be a problem if that fails, but I was just looking for some time to
hunt down these apps and change their data source.

Thank you,

Dave

.

Relevant Pages
Loading