all groups > sql server clustering > april 2007 >
You're in the

sql server clustering

group:

SQL 2000 on Win2k3 Cluster



SQL 2000 on Win2k3 Cluster jkf1024
4/26/2007 7:52:00 AM
sql server clustering: I am trying to install a named instance of SQL Server 2000 on an
Active/Passive 2-node cluster on Windows 2003 Server. The installation
proceeds until near the end, then I get the message: "The cluster resource
failed to come online." When I click OK, a message appears saying I should
install SP3. The SQL setup then proceeds to clean up the installation,
leaving nothing in the installation directories.

I have followed the workaround instructions in KB 815431, using the Client
Network Utility to create a named pipes alias but the problem persists. Any
Re: SQL 2000 on Win2k3 Cluster Geoff N. Hiten
4/26/2007 3:00:55 PM
Most likely your install disk is SQL 2000, not SQL 2000a. SQL 2000a will
have an i386 folder with a 2003 date while SQL 2000 will have a 2000 year
date. I have seen many Windows 2003 systems fail to install SQL 2000 and
work fine with SQL 2000a. You will still need the alias information to
complete the install.

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




[quoted text, click to view]
Re: SQL 2000 on Win2k3 Cluster jkf1024
4/27/2007 12:52:02 AM
Installation was successful after creating the named pipes alias on the
second cluster node also. KB 815431 only refers to creating the alias on the
primary node.

[quoted text, click to view]
AddThis Social Bookmark Button