Re: question about patching MSDE 2000
From: Luca Pugliese (luca_pugliese@virgilio.it)
Date: 07/16/02
- Next message: msspeeder: "sqlserver lead a system crash"
- Previous message: Tibor Karaszi: "Re: DB SUSPECT"
- In reply to: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Next in thread: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Reply: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Luca Pugliese" <luca_pugliese@virgilio.it> Date: Tue, 16 Jul 2002 00:20:39 -0700
>-----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 >> > > >. >
- Next message: msspeeder: "sqlserver lead a system crash"
- Previous message: Tibor Karaszi: "Re: DB SUSPECT"
- In reply to: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Next in thread: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Reply: Richard Waymire [MS]: "Re: question about patching MSDE 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
