Re: SQL 2000 and WIndows 2003 3 node cluster

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 02/28/04

  • Next message: Stephen Strong: "RE: Large transaction log causing write performance hit on cluster" 
    Date: Sat, 28 Feb 2004 16:11:59 -0500

    Make sure you start with this KB article
    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;en-us;815431&Product=sql2k

    Check that all your host nodes are up and joined to the cluster and can
    acess any required resources.

    Install each instance. Reboot each node. Install SQL Service Pack 3a.
    Reboot each node.
    Repeat for each instance. SQL install may not indicate that a reboot is
    necessary at each step, but I found NOT rebooting after each install caused
    the next install to fail.

    Be sure and remove the Named Pipes Aiases or SQL agent jobs may fail
    semi-randomly. 

    -- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Jason" <jdheltne@compassnet.com> wrote in message
news:efqsI1i$DHA.2056@TK2MSFTNGP11.phx.gbl...
> Does anyone have a step by step for setup of a SQL 2000 A/A/P cluster on
> Windows 2003?  I just want to make sure I get all the components installed
> in the correct order.
>
> thanks,
>
> Jason
>
>
  • Next message: Stephen Strong: "RE: Large transaction log causing write performance hit on cluster"

    Relevant Pages

    • Re: WSS 3.0 question
      ... I followed the advise given in removing WSS 3.0 etc, ... the server is complaining that the SQL service(?) was tempered with or corrupt. ... I may just instal the SQL server as I was going eventuall use it anyway. ... If WSUS 3.0 is installed, I would suggest you uninstall it and then you install WSS 3.0. ...
      (microsoft.public.windows.server.sbs)
    • Re: Trying to Move Group - SQL Instance Wont Start
      ... You can do a maintenance install and add the new nodes. ... "maintaining a failover cluster" for recovery from failure scenario 1. ... Senior SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
      (microsoft.public.sqlserver.clustering)
    • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
      ... While attempting to install SP4, it comes up immediately after I ... to be on one of the nodes that can bring SQL Server online and apply SP3a, ...
      (microsoft.public.sqlserver.clustering)
    • Re: Any help here???
      ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: how do I change the user install wizard to create user folder in different location?
      ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
      (microsoft.public.windows.server.sbs)