Re: Microsoft Security Bulletin MS02-034

From: Doug Briggs (doug@rdbriggs.com)
Date: 07/11/02


From: doug@rdbriggs.com (Doug Briggs)
Date: 11 Jul 2002 09:46:52 -0700


Has anyone had a problem running servpriv.exe? I followed the
directions and got the error "Instance Not Found". The server is
operating and the instance name I enter is the name that appears in
the SQL Server Enterprise Manager under SQL Server Group.

Thanks,

Doug Briggs

"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: Cannot Debug Stored Procs from VS.NET
    ... for debugging stored procedure in XP after installing the hotfix. ... is it possible for your to change the SQL Server startup account ... Online Partner Support Specialist ...
    (microsoft.public.sqlserver.programming)
  • Re: How to uninstall an incomplete Hotfix?
    ... The forum for SQL Server 2008 ... Windows Update then requested I install "Hotfix for .NET Framework ...
    (microsoft.public.windowsupdate)
  • Re: Microsoft Security Bulletin MS02-034
    ... We're aware of the need for a better hotfix installation story and we're ... > Is there a good reason why the SQL Server security team can't ship ... >> path for this SQL Server instance>\Binn folder and the Sqlservr.pdb ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Security Bulletin MS02-034
    ... We're aware of the need for a better hotfix installation story and we're ... > Is there a good reason why the SQL Server security team can't ship ... >> path for this SQL Server instance>\Binn folder and the Sqlservr.pdb ...
    (microsoft.public.security)
  • Re: ESENT 215
    ... suggest you apply the hotfix KB935465 on SBS to see if it help. ... An updated version of Sqlvdi.dll is now available for SQL Server 2000 ... you can backup your SBS ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)