Re: Microsoft Security Bulletin MS02-034

From: Richard Waymire [MS] (rwaymi_ms@microsoft.com)
Date: 07/11/02 

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Thu, 11 Jul 2002 12:42:27 -0700

We're aware of the need for a better hotfix installation story and we're
working on it...

Keep your eyes on this space for info on SP3 later this year :-) 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"James" <james.news@reather.com> wrote in message
news:e6jz1eKKCHA.2736@tkmsftngp13...
> "Jerry Bryant [MS]" <jbryant@online.microsoft.com> wrote in message
> news:OC4jemJKCHA.2324@tkmsftngp13...
> > Title: Cumulative Patch for SQL Server (Q316333)
>
> Is there a good reason why the SQL Server security team can't ship
> self-installing hotfixes like those for (almost) every other MS product?
I
> know an MSI file is far too much to ask for, but how about a
self-installing
> .exe   ;-)  ?
>
> These n-step manual procedures [see below] are getting to be a *real* pain
> when you've got lots of servers to update and especially now that SQL
seems
> to be needing a new security rollup almost every other month.
>
> Alternatively, can you give us the ETA of SQL2k SP3?  :-)
>
> Thanks,
>
> James
>
> >
>
============================================================================
> >                           Standard Hotfix Installation Steps
> >
>
============================================================================
> >
> > 1. Install SQL Server 2000 Service Pack 2. Do not proceed any further
> until
> > you
> >    successfully install SQL Server 2000 Service Pack 2.
> >
> > 2. Shut down the Microsoft SQL Server and SQL Server Agent services.
> >
> > 3a. Make a backup copy of the Sqlservr.exe, Odsole70.dll, Xpqueue.dll,
> > Xprepl.dll,
> >    Xpweb70.dll, Xplog70.dll, and Xpstar.dll files from the <installation
> >    path for this SQL Server instance>\Binn folder and the Sqlservr.pdb
> file
> > from the
> >    <installation path for this SQL Server instance>\Binn\Exe folder.
> >
> > 3b. Make a backup copy of Impprov.dll file from
<%ProgramFiles%>\Microsoft
> > SQL Server\80\COM directory.
> >
> > 4. Copy the Sqlservr.exe, Odsole70.dll, Xpqueue.dll, Xprepl.dll,
> > Xpweb70.dll,
> >    Xplog70.dll, and Xpstar.dll files from the hotfix self-extracting
> >    archive into the <installation path for this SQL Server
instance>\Binn
> > folder
> >    and then copy the Sqlservr.pdb file into the <installation path for
> this
> > SQL Server
> >    instance>\Binn\Exe folder.
> >
> > 4b. Copy the Impprov.dll file from the hotfix self-extracting archive
into
> > the
> >    <%ProgramFiles%>\Microsoft SQL Server\80\COM directory.
> >
> > 5. Start the Microsoft SQL Server and SQL Server Agent services.
> >
> > 6. Connect as a member of the system administrator (sa) role or as the
sa
> by
> > using
> >    SQL Query Analyzer or the osql utility (osql.exe), and then execute
> >    Qfe356326.sql and Qfe356938.sql.
> >
> > 7. Run the Servpriv.exe tool from the command prompt. When you run this
> > tool, specify
> >    a SQL Server 2000 instance to set the appropiate priviledges on the
> > corresponding
> >    service registry keys. For more information on Servpriv.exe, see the
> > "Information
> >    About Servpriv.exe" section, located at the end of this file.
> >
> > 8. Test the scenario for the bug fixed by this build to verify that the
> fix
> > resolves
> >    your problem. Notify Microsoft PSS immediately if your problem is
still
> > unresolved.
> >
> > 9. If, for any reason, you encounter a problem with this hotfix build,
> > follow the
> >    instructions in the section titled "Uninstall Hotfix Installation
> Steps."
>
>
>

Relevant Pages

  • RE: Error Code: 1073807364 sql server 2005
    ... contain the files that are required during the installation of SQL Server ... In the D:\SQLServer2005 folder, ... Setup.exe to start the SQL Server 2005 Setup program. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error 7619 - Cannot enable FTS on any database
    ... logged on as Admin or as a member of the Admin Group on the server where SQL ... re-try deleting the \MSSearch folder again and ... Then using your SQL Server 2000 installation CD re-install via "Custom ... Installation" the Full-Text Search component. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: in regards to MS02-034
    ... The files you should backup are the ones in the BINN folder where you ... installed SQL Server to. ... > what is the installation path for my instance.. ...
    (microsoft.public.sqlserver.security)
  • Re: Installation failure
    ... good tool to analyse missing hotfixes is Microsoft Baseline Security ... Microsoft Network Security Hotfix Checker Tool Is Available ... SQL Server MVP ... > The installation of SQL server takes a long time after which a messagebox is displayed which says the installation has failed and a hotfix 8.00.0568 should be installed. ...
    (microsoft.public.sqlserver.setup)
  • Re: sql 2005 installation help
    ... if you try to use only the first CD's files to install all available features and components of SQL Server 2005 then it'll probably fail if Setup can't find the other folder. ... Ensure that these folders are at the root level so that you'd probably not meet an unexpected installation error related to folder names and locations. ...
    (microsoft.public.sqlserver.setup)