Solved

SQL 2000 sp4 applied, but still shows sp3

Posted on 2008-10-30
2
733 Views
Last Modified: 2008-10-31
I too am trying to install SQL 2000 sp4 on 2003 server (sp2).  

On the server, opening enterprise manager, I right click on Local database and select properties
console root
-->ms sql servers
---->sql server group
------>local

It shows product version 8.00.818 (SP3)

I have applied SQL 2000 sp4 multiple times w/o error (although it does seem to go quickly).  I've tried running it with the serice stopped, after rebooting, rebooting after, etc with no luck.  Still shows sp3.  

In ms kb article 321185 I found notes to check the versions

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
(run on master of local database instance)

returns
 8.00.818      SP3      Standard Edition


KB also said to check version of Sqlservr.exe file on server.

Search shows
c:\mssql7\binn\sqlservr.exe (version 2000.80.818.0)
c:\sql2ksp4\x86\binn\sqlservr.exe (version 2000.80.2039.0)
c:\mssql7\x86\binn\sqlservr.exe (version 2000.80.2039.0)


according to the kb .2039 is sp4 and the other is a form of sp3 with a patch installed.

I'm assuming that when I apply the sp4 it is not applying it to the right location.  The default when prompted is the
c:\sql2ksp4.  I ran it a second time and changed it to use c:\mssql7.  Still isn't showing correctly.

Please help me figure out how to apply sp4 correctly show it shows as applied.  I thought this was done a long time ago until a security audit flagged it as a risk.  

Thanks!


0
Comment
Question by:okcuser
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22846772
what you call "apply" is just the extract of the actual setup.
go to the folder c:\sql2ksp4, you find a setup to run there, which will then run the actual sp4.

note: your sql server service should run when you try to apply the sp4, as it has to validate the username/password you supply...
0
 

Author Comment

by:okcuser
ID: 22850611
OK - I am just plain stupid ... what a mess.  Thank you so much for taking the time to point it out to me.  I have successfully installed the sp now.  Thanks!
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question