Re: SQL2000 Cluster on Windows 2003 SP1 Cluster

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



"Athif [MVP]" <zkathif@xxxxxxxxxxx> wrote in message
news:1133345770.471495.276920@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
>


.

Relevant Pages

  • Installation fails when creating virtual resource on node
    ... I have spent 2 full days trying to install SQL Server 2000 Failover ... installation will not start the SQL cluster resources and complete. ... options for a single-instance clustered database (virtual server, name, IP, ... Installing a local database and then installing a new ...
    (microsoft.public.sqlserver.clustering)
  • Re: Upgrading Windows 2000 cluster to Windows 2003 Cluster.
    ... I made absolutely sure I had all the drivers and software for Windows ... worked as a cluster host node, I upgraded its peer node, also in-place. ... You must re-run any service packs and hotfixes after the install when you ... SQL server 2000 which we installed it as a virtual server. ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to cluster sql in a 2003 cluster
    ... For the most part setup on a Windows 2003 cluster is identical to setup on ... SQL Server 2000 does not support mount points. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Rolling Upgrade of SQL2000/W2000 cluster to SQL2000/W2003
    ... Could someone out there please point me to a good guide to complete a rolling upgrade of a Windows 2000 SQL Server 2000 2 node cluster to Windows 2003 SQL Server 2000 cluster? ...
    (microsoft.public.sqlserver.server)
  • Re: Logins created by default
    ... always created automatically during installing a SQL Server using Windows ... Based on my testing in installing SQL Server with Windows Authentication ...
    (microsoft.public.sqlserver.security)