Re: Is WINS needed for a Win2K3 / SQL Server 2000 Cluster?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



"Greg Bradshaw II" <GregBradshawII@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:57BF398D-BE47-4CDA-B867-41F35166A58D@xxxxxxxxxxxxxxxx
Hello. We are currently using Windows 2003 and SQL Server 2000 to set up
a
2-node cluster with named instances. The problem that we are having is
that,
if a server is rebooted, the groups that are supposed to fail over, do
not.
They just go offline.

We are in the process of upgrading to Windows 2003 AD from an NT domain.
I've read in another Microsoft article that, if you're using Windows
2000/SQL
Server 2000, MSCS requires WINS. Right now, we're trying to decide if we
should configure a WINS server for the SQL Cluster Failover to work
properly.

Actually, WINS is not required, but it can be helpful. If you configure your
cluster using security best practices, then you will not need WINS, however,
if you don't do that, then WINS may benefit you.

I discuss the why and why nots here:
http://msmvps.com/blogs/clusterhelp/archive/2005/08/05/61710.aspx


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp


.



Relevant Pages

  • Re: Clustering Windows 2008
    ... I found out our EVA supports Windows 2008 but in the OS type on the EVA I ... Now the cluster is up and I am just trying to figure it out.... ... This prevents accidental data corruption that is caused when a server ... release the reservation and allow a new server to access the VDisk. ...
    (microsoft.public.windows.server.clustering)
  • 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: File Server on R2 with Clustering
    ... Windows 2003 enterprise is the O/S. ... Install Cluster service on both servers. ... Use the File Server Migration Tool to migrate the data from the standalone ...
    (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)