Re: How to install service pack 3a on a failover cluster

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

From: pepe (pepe_at_discussions.microsoft.com)
Date: 11/19/04


Date: Fri, 19 Nov 2004 06:43:09 -0800

Let me backtrack a little. When I said that the install went well, I should
have said that the unpacking of the install files went well :) I know, dumb...

Anyway, when I actually did try the service pack install it asked me to
supply the name of the virtual server but it would not take the name. Our
server virtual name is ncm-sql. We have two instances of sql running so I
tried the names of one of the sql instances, in this case it was sqlncm and
it accepted it. I was wondering why.

I believe the answer is that the instructions mean "virtual sql server" not
virtual cluster server" even though they say "virtual server".

The rest of the install went fine and then I moved the two cluster groups to
the second node and rebooted the first node. At this time several of the sql
cluster resources started to fail. Of course, I panicked. But I just waited
for the first node to come back up and then I moved the groups back to the
first node and now they are working find.

However, when I search for the ssnetlib.dll file to check the version, the
folder that reflects the instance that I used to apply the service pack shows
version 2000.80.766.0 which implies sp3a. But the version for the instance
that I didn't upgrade still shows 2000.80.534.0. I am guessing that I need to
re-apply the service pack but when it asks for the virtual server name, I
should use the name of the second instance?

pepe

"Rodney R. Fournier [MVP]" wrote:

> So, the install completed and asked you to reboot the Active node right?
>
> Cheers,
>
> Rod
>
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
>
> "pepe" <pepe@discussions.microsoft.com> wrote in message
> news:F6993B99-3C24-43EB-ABE2-567967B03F1C@microsoft.com...
> >I think I spoke too soon.
> >
> > I checked the sql version in query analyzer and it says
> > Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50
> > Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on
> > Windows
> > NT 5.0 (Build 2195: Service Pack 4)
> >
> > I'm guessing that this service pack didn't get applied properly. Any
> > thoughts on what I could do next?
> >
> > Thanks,
> > pepe
> > "pepe" wrote:
> >
> >> Thanks to both of you. The document that you referred me to Uttam was one
> >> I
> >> found several months ago but didn't find it online again. I did find a
> >> paper
> >> copy i had printed. Rodneys "English" interpretation was just what I
> >> needed
> >> to confirm what I was going to do was what I should be doin.
> >>
> >> So far, so good. Service Pack install went well.
> >> Thanks again for your time.
> >> pepe
>
>
>



Relevant Pages

  • Re: about another instance of virtual server on sql2000 cluster
    ... Multiple instances on a cluster look and act just like multiple ... Microsoft SQL Server MVP ... > the new instance of sql virtual server is myclustersql02\myclustersql02 ... You can specify the same path, and the install will create a ...
    (microsoft.public.sqlserver.clustering)
  • Single node cluster with multiple instances but all as default ins
    ... and I am trying to install one instance onto each virtual ... server set up for SQL installation, and the instance should all be default so ... I logged into virtual server SQL1, installed a default sql instance (during ... Single node cluster would not support this at all ...
    (microsoft.public.sqlserver.clustering)
  • Re: cluster with 1 server ok and second not,...
    ... > The DB will stay on online on the primary node Y while you install X. ... Uninstall SQL from node X ... > Enter the DB name for Virtual Server ... Install Node X ...
    (microsoft.public.windows.server.clustering)
  • Re: about another instance of virtual server on sql2000 cluster
    ... i have isntalled the new virtual server and it work fine but i see that the ... Perhaps because all new instance of virtual server that i install are a "sql ... > location for its binaries. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate DTC
    ... The SQL install is cluster aware. ... Create a cluster on the first node and ... Leave both machine powered on and run the SQL ...
    (microsoft.public.sqlserver.clustering)