RE: Installing SP4 on SQL 2000

Now thats interseting ... 8.00.194 is not SP3 either.

Looks like when SP3 was installed on your computer something went wrong on
the database engine component of the patching. As not all the components
were brought up to proper version 8.00.760.

Try installing SP3a, to see if it can fix that issue first. Then maybe SP4
will work.

SQL Server 2000 SP4, x86
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en#filelist
Download: SQL2000-KB884525-SP4-x86-ENU.EXE

SQL Server 2000 SP3a, x86
http://www.microsoft.com/downloads/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en#filelist
Download: sql2ksp3.exe

If neither of these work, question is how much you got on the server to
rebuild it? It seems like there is issue on your install. Service Patching
for SQL Server 2000 has so far never gave me that issue (where setup doesn't
show up). Thanks.

Ref Version Doc: http://support.microsoft.com/kb/321185/

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

I ran select @@version and the text returned was:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 3)

So it seems nothing is happening, which is what I have suspected all along.
Why on earth is this process so convoluted? How can I install these service
packs?
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

Hmm normally it doesn't run in silent mode. I'll check when I get to work
tomorrow to see where the log files are. But for version information you can
type ..

SELECT @@Version

SQL Server 2000 SP4 is 8.00.2039.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

An afterthought is, maybe the install happens silently and everything has run
and installed OK?
If that is the case, is there an @@ function that will confirm the Service
Pack Version that is installed?
--
Thanks
David G
Albury, Australia


"David G" wrote:

Hi Mohit,
I'm out of ideas, I've checked where you suggested (not exactly the same
path) and there are no log files. I'm trying to run sqlstp.exe from the
x386\setup folder but no luck, it seems to open but then nothing happens.
Maybe it won't matter if I just use SP3 version as I'm only using it on my PC
at home. (No network). Ideas appreciated.
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

When you are installing the Patch for SQL Server it will check for the
services running, it will war you that the services are active and the files
are locked. But you do not have to shut down the services, infact if you do
some of the functionality of the patch can fail. Because most of the service
packs also apply database changes to the system databases (thus the backup
required!).

Another place to check for install log files is in C:\Program
Files\Microsoft SQL Server\80\Install\

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

Thanks,
I'm now wondering, should I have SQL Server on? I got the impression from
reading the Microsoft files that everything should be off, i.e. all SQL
Server stuff, I even turned off the Sql Server Service Manager in the system
tray on the right hand side of the task bar. Maybe I've got the wrong
impression.
I have checked for log files in c:\windows *.log and there are no files on
or around the time I started the install. It is still a mystery.
--
Thanks
David G
Albury, Australia


"Mohit K. Gupta" wrote:

Hi David,

Try going to the SETUP LOGS for the SP4, for SQL Server 2000 I believe
they are in C:\Windows\*.log files. Look at the files to see if the setup
was successful or there were issues.

If you can't find any log files, I would try to stop and start it again.
Also re-download the binaries from Microsoft just in case there is a
corruption issue.

Thanks.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCITP: Database Administrator
MCTS: SQL Server 2005
http://sqllearnings.blogspot.com/


"David G" wrote:

Hi,
I'm a SQL Server newbie. I hope this is the right group. Basically I can't
get the SP4 after I've downloaded it, to run.

I've recently downloaded SP4 since I have reinstalled SQL Server 2000 which
I think is SP3. Anyway, I have downloaded the Database components exe file
and the Analysis services exe file. When I double click each file they
extract each group of components fine. The problem comes in trying to RUN
each of these.

Following the instructions from the MS web site I have run the Setup.bat
file and NOTHING seems to happen. I have run the setup.exe in the x86/setup
folder and it says setup is already running. Basically nothing seems to run
and indicate that it is actually installing. Now I'm worried something more
sinister has gone wrong. I know the MS Site has the instructions but they
seem awfully confusing or advanced or both. Is there a straight forward way
to do this? Could someone assist?

--
Thanks
David G
Albury, Australia
.

Relevant Pages

  • RE: Installing SP4 on SQL 2000
    ... As you said this is a fresh install, so it should not be an issue. ... If you are installing are installing a fresh version of SQL Server 2000, ... MCITP: Database Administrator ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... maybe the install happens silently and everything has run ... "David G" wrote: ... Another place to check for install log files is in C:\Program ... should I have SQL Server on? ...
    (microsoft.public.sqlserver.setup)
  • Re: Why do I need to restart the SQL service?
    ... > I use Wise Installation utility to install MSDE 2000A. ... what I do within the app is: ... Check to see if the database exists. ... > SQL Server does not exist or access denied. ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL SERVER 2008 Express + SP1
    ... Again there are three service pack setups which are provided by Microsoft. ... Are u sure you are using correct version for your install? ... DB Dev SQL Server 2005 ... Script level upgrade for database 'master' failed because upgrade step ...
    (microsoft.public.sqlserver.setup)
  • RE: Installing SP4 on SQL 2000
    ... I'm willing to continue because I need this database to be up and working on ... SQL Server 2000 SP3a, x86 ... It seems like there is issue on your install. ... "David G" wrote: ...
    (microsoft.public.sqlserver.setup)