Re: question about patching MSDE 2000

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

From: "Richard Waymire [MS]" <rwaymi_ms@microsoft.com>
Date: Tue, 16 Jul 2002 10:44:28 -0700

Great, can you post the version number reported by select @@version? 

--
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:1932001c22c99$49869390$3bef2ecf@TKMSFTNGXA10...
>
> >-----Original Message-----
> >So it's  a named instance?  Are you applying the patch to
> a named instance?
>
> No, it's not a named istance. As I said clearly, it's just
> a default istance installed on a drive different than C:.
> To install a named istance MS documentation says to add to
> the setup.ini the line 'INSTANCENAME="MyInstance"' and I
> didn't do it.
>
> >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.
> >
>
> I assure you that I read the readme.txt thoroughly, but it
> tells that you have to order the CD only if you installed
> MSDE 2000 using a file different than sqlrun01.msi and I
> saw in the registry that I used sqlrun01.msi to install
> it.
>
> >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.
> >
>
> As I said, I read the documentation thoroughly, and I
> verified the version just like you said with  osql.exe,
> like explained in the readme file.
>
> Thank you,
>
> --
> Luca Pugliese
>
>
> >--
> >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: .NET and MSDE
    ... So it will not harm anything if they install the regular ... patch for MSDE as well? ... >the sql2kdesk.exe patch won't apply to the NETSDK ... >information for users of the Microsoft .NET Framework SDK ...
    (microsoft.public.sqlserver.security)
  • How can I tell that the blaster patch is installed without having to go to the w
    ... To verify that the patch has been installed on the ... Windows NT 4.0 Terminal Server Edition: ... >to me on the site to install, ...
    (microsoft.public.windowsxp.security_admin)
  • 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: Wrong MSDE installed
    ... That is the command line to install a new default instance. ... This will upgrade the existing instance but do nothing to get SBS Monitoring and Sharepoint installed. ... They use WMSDE not MSDE. ... those folders are as you say on my SBS 2003 server that has been upgraded to SP1. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Great Plains problem - NOT SOLVED :(
    ... It doesn't matter if the new instance of MSDE is ... but I now have a new instance of MSDE working and the SBS backup also ... install a new instance the install quit with an error. ... server for the customer before they install it on their server. ...
    (microsoft.public.windows.server.sbs)