Re: MS03-31 install issue

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 08/13/03 

Date: Wed, 13 Aug 2003 13:28:52 -0400

Could you post the file name of the executable? Just want to make sure it is the hotfix for SQL2K (32-bit). It should be:

SQL2000-KB815495-8.00.0818-ENU.exe 

-- 
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:015b01c361be$00e760f0$a401280a@phx.gbl...
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: Reinstalling MSDE 2000 fails (MDAC?)
    ... can I patch setup for using this new hotfix? ... > if named then ..\Program Files\Microsoft SQL Server\MSSQL$InstanceName ... > delete this folder ... > Since you tried to reinstall, you will also find the attempt to install in ...
    (microsoft.public.sqlserver.setup)
  • SQL Agent is not allowed to run
    ... On SBS2003 Premium with ISA, but no SQL Server installed, Microsoft Baseline ... SQL instances Monitoring and Sharepoint. ... The build number of SQLSERVR.EXE and HotFix package did not match. ... INSTALL FAILURE: Hotfix failed to apply the patches on instance SHAREPOINT, ...
    (microsoft.public.windows.server.sbs)
  • MS03-31 install issue
    ... >that the servername is correct. ... >>Trying to install the hotfix on a sql2k default ... >>Verifying Instance MSSQLSERVER to see if it qualifies ...
    (microsoft.public.sqlserver.security)
  • Re: Different sp:s on cluster nodes
    ... SQL requires single-user access ... during the SP or Hotfix to update system objects within the database. ... > I thinking of configuring a 2 node, single instance cluster. ... Upgrade the passive node, switch passive node to ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL Agent is not allowed to run
    ... "Daniel" schreef in bericht ... > On SBS2003 Premium with ISA, but no SQL Server installed, Microsoft ... > SQL instances Monitoring and Sharepoint. ... > The build number of SQLSERVR.EXE and HotFix package did not match. ...
    (microsoft.public.windows.server.sbs)