I am presently trying to install a windows cluster on windows 2003
enterprise edition. After i configure the cluster service on the windows
server. I will require to install a default instance of SQL 2000 although the
version is old i will update it with sp4. My client then wants to have a
default instance of SQL 2005 installed and therfore have a default instance
of SQL 2000 and I assume a default instance of SQL 2005 will be installed to
the server. The question is simple once the install is completed and tested
for failover. Is it possible to install additional instances of SQL2000 only
after the default instance of SQL2005 is installed. IF not then my client

You cannot have more than 1 default instance per cluster - regardless of the
edition/version of SQL Server. SQL 2000 must be installed before SQL 2005.

HTH

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
[quoted text, click to view]
I am presently trying to install a windows cluster on windows 2003
enterprise edition. After i configure the cluster service on the windows
server. I will require to install a default instance of SQL 2000 although
the
version is old i will update it with sp4. My client then wants to have a
default instance of SQL 2005 installed and therfore have a default instance
of SQL 2000 and I assume a default instance of SQL 2005 will be installed to
the server. The question is simple once the install is completed and tested
for failover. Is it possible to install additional instances of SQL2000 only
after the default instance of SQL2005 is installed. IF not then my client
does not want to add the SQL 2005