OK. This is getting frustrating. I have tried over and over to set up SQL Server
2000 in my 2 node cluster. I keep getting the following messages:

This one occurs during the setup:

----- CUT -----
The cluster resource failed to come online. If extended information was reported
by the clustering service it can be obtained from the event log.
----- CUT -----

Look in the event logs and found this message:

----- CUT -----
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server
2000 Desktop Engine (also called MSDE) that has known security vulnerabilities
when used in conjunction with the Microsoft Windows Server 2003 family. To
reduce your computer's vulnerability to certain virus attacks, the TCP/IP and
UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been
disabled. To enable these ports, you must install a patch, or the most recent
service pack for Microsoft SQL Server 2000 or MSDE from
http://www.microsoft.com/sql/downloads/default.asp
----- CUT -----

Fire up Cluster Administrator Console and, look, SQL Server failed to start.
Click the 'OK' button in the installation, and SQL Server is uninstalled and
removed from the Cluster Administrator Console. I know I have installed before
and was able to install the service pack.

Is the fact that the network ports have been disabled the reason for my
problems? Or am I missing something else?

Thanks for any help!!

Darrell,

If this is a W2K3 cluster you have applied SQL2000 SP3A haven't you? This is
the lowest level to start with W2K3.

Chris Wood

"Darrell" <Darrell.Wright.nospam (AT) okc (DOT) gov> wrote

I can't even get SQL 2000 to install so I can apply the Service Pack to it!

Chris Wood wrote:

You are likely experiencing

http://support.microsoft.com/default...b;en-us;329329

First, make sure you are installing the SQL 2000a release. The i386
directory should have a 2003 date on SQL 2003 releases. If you are
installing a clustered instance you will need to follow this article:

http://support.microsoft.com/default...b;en-us;815431

Apply SQL Service Pack 3a (or SP4 if you don't have AWE enabled) immediately
following your base installation.

Geoff N. Hiten
Microsoft SQL Server MVP

"Darrell" <Darrell.Wright.nospam (AT) okc (DOT) gov> wrote