Re: How to cluster sql in a 2003 cluster

From: Amit Kumar [MSFT] (amitk_at_online.microsoft.com)
Date: 05/28/04

  • Next message: americanone: "Federaton Servers" 
    Date: Thu, 27 May 2004 17:35:13 -0700

    For the most part setup on a Windows 2003 cluster is identical to setup on
    a Windows 2000 cluster.

    Things to watch out for:

    SQL Server 2000 does not support mount points. So if your Windows 2003
    cluster has mount points you will have to remove them.

    SQL Server 2000 support for mounted volumes
    http://support.microsoft.com/default.aspx?scid=kb;[LN];819546

    SQL Server 2000 does not support Terminal SErver installed on a Windows
    2003 cluster

    SQL Server 2000 Cluster Does Not Install on Windows Server 2003-Based
    Computers Where Terminal Services Is Installed
    http://support.microsoft.com/default.aspx?scid=kb;[LN];301520

    If you are installing a named instance then you will ahve to create an
    alias on the Windows 2003 server where you are running setup from.

    PRB: 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;[LN];815431 

    -- 
--Regards
  Amit Kumar
This posting is provided "AS IS" with no warranties, and confers no rights.
"Please do not send e-mail directly to this alias. This alias is for
newsgroup purposes only."
"TomasG" <anonymous@discussions.microsoft.com> wrote in message
news:45D66029-6798-4B34-AFA3-3EF825AF3DEB@microsoft.com...
> I have set up my 2003 cluster. I think everything works fine, but when i
tried to setup sql in a cluster something went wrong. how am i supposed to
setup sql in a cluster on a 2003 box?
>
> Power Edge 2650
> Windows 2003 Enterprise
> Sql 2000
> external scsi disk array.
  • Next message: americanone: "Federaton Servers"

    Relevant Pages

    • 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: evicting a node from multi instance cluster
      ... Even though you are running "setup", ... Setup can also be used if not evicting a node from the cluster. ... I have a three node cluster with three virtual sql server 2005 installed. ...
      (microsoft.public.sqlserver.clustering)
    • Re: evicting a node from multi instance cluster
      ... thanks tom, it help a lot. ... Even though you are running "setup", ... Setup can also be used if not evicting a node from the cluster. ... I have a three node cluster with three virtual sql server 2005 installed. ...
      (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)
    • 2003 Cluster Lost Data Drive
      ... Here's the setup: ... however I cannot connect to cluster via Cluster Administrator. ... connect to my virtual instances via SQL Server Enterprise Manager. ... both the Quorumand Datadrives. ...
      (microsoft.public.windows.server.clustering)