Re: Server availability in an Active Passive Cluster

If you leave the service running after clustering, then yes, you will get a
response. The virtual server CXSQL will have a different IP address than
either host node.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP


<pavman27@xxxxxxxxx> wrote in message
news:1152749127.015073.249110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Windows Server 2008 Readiness Team ... cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine ... member of the NLB cluster, setup NLB on it, plug the NICs ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... Once again, ARP is an RFC standard, if you are having to make static entries in unicast mode, then your network device is not in compliance. ... Windows Server 2008 Readiness Team ... I was feeling nervous about our teaming-capable adapter as I read it might be sending out heartbeats, so I disabled it AND configured the cluster on a separate DLink card in multicast mode. ... I thought that the litmus test was that the router functions fine when no NLB is installed, but when it is, things start going screwy. ...
    (microsoft.public.windows.server.clustering)
  • Re: NLB Cluster - Ping fails or long time to reply from outside local subnet - SOLVED
    ... One server with no cluster configured - all works ok. ... When static ARP mappings are added all works ok. ... I thought that the litmus test was that the router functions fine when ...
    (microsoft.public.windows.server.clustering)
  • Re: Exchange install failed
    ... Could it be I have the server's DNS entries as our secondary DNS ... I will change the DNS entries on the server to point to ... In fact the cluster itself passed all readiness ... an error that the computer account for the Exchange virtual server ...
    (microsoft.public.exchange.setup)
  • Re: Data Center Move Question!
    ... Cluster server. ... address resource in the cluster group. ... address resource for the exchange virtual server and change it for the new ...
    (microsoft.public.exchange.admin)
Loading