Hello Folks,

By tomorrow, I will be installing SQL2000 Cluster on Windows 2003 SP# 1
Cluster and was wondering for any known issues. Since SQL cluster sits
on Windows, I will be responsible for both Windows & SQL Clustering.

Based on my research, yes, we can implement this scenario but I need to
install at least SQL SP 3a and MS03-031 Patch for Microsoft SQL Server
to patch vulnerabilities & that's fine. A very good insight by Uttam
Parui on
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wcd020703/wcdblurb020703.asp

Pre-requisites:

Enabled Network DTC access
Terminal Services is not installed
No Mounted drives
Services SNMP WWW, ANTIVIRUS are stopped as per KB 183692

Did I miss any thing?

Good day,
Mohammed Athif Khaleel
MVP - Windows Server
PatchAholic...The WSUS Blog!: http://msmvps.com/athif

You are installing first on test equipment right?

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training


[quoted text, click to view]

There is one special work-around for installing a named instance on a
Windows 2003 cluster.

Installation of a named instance of SQL Server 2000 virtual server on a
Windows 2003-based cluster fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;815431


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



[quoted text, click to view]

Athif,

Some time ago, I presented the webcast for SQL 2000 Cluster on Windows 2003. You may find this useful

TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default.aspx?scid=kb;en-us;888121


Yes, for SQL Server 2000, you would atleast install SP3a + MS03-031 or better install SP4. For Windows 2003, install SP1 for Windows 2003.

HTH,

Best Regards,

Uttam Parui
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

Hi Uttam,

As I have already stated in my original post, YES, I have been thru
your excellent webcast.. KUDOS.

Rodney ,
I am doing this in real time :-)

Jeff,
I will be using default instance only and will re-connect the database.
Actually, I am re-building the new cluster and will then re-connect the
database from the old cluster for which I have a back up.

Happy Patching,
Mohammed Athif Khaleel
MVP - SUS / WSUS
WSUS Blog: http://msmvps.com/Athif

Hi Uttam,

As I have already stated in my original post, YES, I have been thru your
excellent webcast.. KUDOS.

Rodney ,
I am doing this in real time :-)

Jeff,
I will be using default instance only and will re-connect the database.
Actually, I am re-building the new cluster and will then re-connect the
database from the old cluster for which I have a back up.

Happy Patching,
Mohammed Athif Khaleel
MVP - SUS / WSUS
WSUS Blog: http://msmvps.com/Athif

OMG! I was in deep trouble with this installation & eventually I
resolved that. I will share my expriences very soon :-)

Thanks,
Athif