Groups | Blog | Home
all groups > sql server clustering > may 2006 >

sql server clustering : Is WINS needed for a Win2K3 / SQL Server 2000 Cluster?


Greg Bradshaw II
5/23/2006 8:21:02 AM
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.

Greg Bradshaw II
5/23/2006 10:19:05 AM
Okay. Now with the Virtual SQL instances being in DNS (forward and reverse
lookup), why would the instances not be failing over properly if WINS is not
required? What am I missing?

[quoted text, click to view]
Rodney R. Fournier [MVP]
5/23/2006 11:27:39 AM
2000 on 2000 will use WINS. 2003 does not require WINS.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner


"Greg Bradshaw II" <GregBradshawII@discussions.microsoft.com> wrote in
message news:57BF398D-BE47-4CDA-B867-41F35166A58D@microsoft.com...
[quoted text, click to view]

Greg Bradshaw II
5/23/2006 11:31:02 AM
No, we don't.

[quoted text, click to view]
Russ Kaufmann [MVP]
5/23/2006 11:51:04 AM
"Greg Bradshaw II" <GregBradshawII@discussions.microsoft.com> wrote in
message news:57BF398D-BE47-4CDA-B867-41F35166A58D@microsoft.com...
[quoted text, click to view]

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

Russ Kaufmann [MVP]
5/23/2006 11:52:02 AM
"Greg Bradshaw II" <GregBradshawII@discussions.microsoft.com> wrote in
message news:C646F7B8-A232-43A3-8FF6-D3454EFE438D@microsoft.com...
[quoted text, click to view]

Do you have the WIndows Firewall installed on any of your network
interfaces?

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

Michael Hotek
5/30/2006 6:01:17 AM
What are you getting in the event log? Is it simply shutting down or does
it try to come online on Node2, fail, and since Node1 is no longer there,
winds up shutting down?

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.


"Greg Bradshaw II" <GregBradshawII@discussions.microsoft.com> wrote in
message news:FEB12CEB-DF6F-4466-8DB3-C99863811324@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button