Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / May 2005

Tip: Looking for answers? Try searching our database.

SQL Setup Fails

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Darrell - 24 May 2005 20:43 GMT
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!!
Chris Wood - 24 May 2005 21:33 GMT
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

> 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:
[quoted text clipped - 28 lines]
>
> Thanks for any help!!
Darrell - 25 May 2005 15:40 GMT
I can't even get SQL 2000 to install so I can apply the Service Pack to it!

> Darrell,
>
[quoted text clipped - 35 lines]
>>
>>Thanks for any help!!
Geoff N. Hiten - 25 May 2005 20:46 GMT
You are likely experiencing

http://support.microsoft.com/default.aspx?scid=kb;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.aspx?scid=kb;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

> 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:
[quoted text clipped - 28 lines]
>
> Thanks for any help!!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.