Re: question about patching MSDE 2000

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

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Mon, 15 Jul 2002 10:55:42 -0700

So it's a named instance? Are you applying the patch to a named instance?
There's a specific note in the sp2 readme.txt for the MSDE download that
when you get that error you need to order a CD from Microsoft in order to
apply the service pack.

Also, how did you verify that the patch was/was not applied?

In this case you should log in to MSDE with osql.exe and run "select
@@version" to check the version number. 

--
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Luca Pugliese" <luca_pugliese@virgilio.it> wrote in message
news:18cff01c22bed$ffd507f0$3bef2ecf@TKMSFTNGXA10...
> hi,
>
> I'm trying to solve a problem for a customer and any help
> would be welcome.
> I'm using the version of MSDE 2000, which was bundled with
> ISS RealSecure.
> I'm trying to patch it using SQL SP2 (the filename of the
> patch is ql2kdesksp2.exe), but although the installation
> of the patch seems to succeed, when I verify the version
> number of sql, I can't see any difference with the number
> I got before applying the patch.
>
> I don't know if the command I'm using is correct or if
> something is missing because documentation on the subject
> is quite complex and difficult to read.
>
> First time I tried to apply the patch, I simply ran the
> setup but I got an error saying:
>
> "This installation package could not be opened. Verify
> that the package exists and that you can access it, or
> contact the application vendor to verify that this is a
> valid Windows Installer package."
>
> then I tried "Setup /p SQLRUN", in this case the
> installation goes well and patches MSDE if I installed it
> on C:, goes well but seems to do nothing to MSDE if I
> installed it on D:
>
> I have to install MSDE on the D: drive, any suggestion on
> how to patch it correctly?
> I'm using this setup.ini to install MSDE on D:
>
> [Options]
> TARGETDIR="D:\Program Files\Microsoft SQL
> Server\Mssql\Binn"
> DATADIR="D:\Program Files\Microsoft SQL Server\Mssql\Data"
>
>
>
> Thank you in advance,
>
> --
> Luca Pugliese
>

Relevant Pages

  • Re: question about patching MSDE 2000
    ... of the installation of MSDE on the D: ... get when I try to patch default instances of MSDE ... >>>So it's a named instance? ...
    (microsoft.public.sqlserver.security)
  • Re: question about patching MSDE 2000
    ... of the installation of MSDE on the D: ... get when I try to patch default instances of MSDE ... >>>So it's a named instance? ...
    (microsoft.public.sqlserver.security)
  • Re: question about patching MSDE 2000
    ... >So it's a named instance? ... Are you applying the patch to ... To install a named istance MS documentation says to add to ... MSDE 2000 using a file different than sqlrun01.msi and I ...
    (microsoft.public.sqlserver.security)
  • Re: Build numbers
    ... I wouldn't use Enterprise Manager for this. ... Vyas, MVP (SQL Server) ... And after applying SP3a and the 8-11-03 patch it ... reinstalled SQL so there souldn't be anything strange with the installation ...
    (microsoft.public.sqlserver.server)
  • question about patching MSDE 2000
    ... I'm trying to patch it using SQL SP2 (the filename of the ... "This installation package could not be opened. ... installation goes well and patches MSDE if I installed it ...
    (microsoft.public.sqlserver.security)