Re: MS03-31 install issue

From: Gerald Bowers (gerald.bowers_at_wachovia.com)
Date: 08/13/03 

Date: Wed, 13 Aug 2003 10:11:58 -0700

Thanks, but 8.00.760 is sp3. This website would be a good
resource for that information:
http://www.sqlsecurity.com/DesktopDefault.aspx?
tabindex=3&tabid=4

As to the OS patch level I agree however that is another
group's concern.
>-----Original Message-----
>Install SP3 for SQL Server 2000 first before applying the
hotfix. I'd also consider applying SP4 + the MS03-026
hotfix on the OS.
>
>--
>Tom
>
>----------------------------------------------------------
-----
>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
>SQL Server MVP
>Columnist, SQL Server Professional
>Toronto, ON Canada
>www.pinnaclepublishing.com/sql
>
>
>"Gerald Bowers" <gerald.bowers@wachovia.com> wrote in
message news:117801c361b8$9203dfb0$a501280a@phx.gbl...
>Trying to install the hotfix on a sql2k default
instance.
>The installer exits with the "no instance on this machine
>qualifies" error. Some additional info:
>
>@@version is: Microsoft SQL Server 2000 - 8.00.760
(Intel
>X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003
>Microsoft Corporation Standard Edition on Windows NT 5.0
>(Build 2195: Service Pack 2)
>
>I compared the SQLHotfix.log to another similar machine
>where it installed successfully and in the one that
fails,
>this is the part that seems to cause it:
>
><Func Name='QualifySQLComputer'>
><Func Name='QualifySQLInstance'>
>Verifying Instance MSSQLSERVER to see if it qualifies for
>this hotfix
>Instance MSSQLSERVER does not meet the requirements for
>this HotFix or there is no such instance installed on
this
>computer
><EndFunc Name='QualifySQLInstance' Return='87'
>GetLastError='997'>
>HotFix Installer did not find any installation or
instance
>of SQL that qualifies for this hotfix
><EndFunc Name='QualifySQLComputer' Return='1168'
>GetLastError='997'>
>No components of SQL found on this computer that
qualifies
>for this package.
><EndFunc Name='SQLHotfix' Return='1168'
GetLastError='997'>
><EndFunc Name='HandlePackage' Return='1168'
>GetLastError='997'>
>
>
>
>So what is QualifySQLInstance really checking and what
>does return code 87 mean?
>
>

Relevant Pages

  • Re: MS03-31 install issue
    ... Columnist, SQL Server Professional ... QualifySQLInstance in the hotfix installer really checks ... >>Verifying Instance MSSQLSERVER to see if it qualifies ...
    (microsoft.public.sqlserver.security)
  • MS03-31 install issue
    ... Trying to install the hotfix on a sql2k default instance. ... qualifies" error. ... HotFix Installer did not find any installation or instance ... <EndFunc Name='QualifySQLComputer' Return='1168' ...
    (microsoft.public.sqlserver.security)
  • MS03-31 install issue
    ... QualifySQLInstance really looks at CSDVersionNumber ... >Trying to install the hotfix on a sql2k default ... >The installer exits with the "no instance on this machine ... >of SQL that qualifies for this hotfix ...
    (microsoft.public.sqlserver.security)
  • Re: MS03-31 install issue
    ... particular server. ... QualifySQLInstance in the hotfix installer really checks ... >Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • MS03-31 install issue
    ... SELECT @@SERVERNAME to make sure ... >Trying to install the hotfix on a sql2k default ... >The installer exits with the "no instance on this machine ... >of SQL that qualifies for this hotfix ...
    (microsoft.public.sqlserver.security)