Learn how to a build a cloud-first strategyRegister Now


SQL Server 2000 latest sp and hotfix issues

Posted on 2008-11-10
Medium Priority
Last Modified: 2012-05-05
A security scan reported my sql 2000 server did not have the latest sp and hot fix applied.  It showed vulnerability details:  Database version=8.00.2039, Latest Hotfix=8.00.2271.  I applied sp 4 per http://www.microsoft.com/technet/prodtechnol/sql/2000/downloads/default.mspx;  and looked at the audit reference http://support.microsoft.com/?kbid=946584.  I had a post audit scan run and it still tells me I have vulnerablitity details Database Version=8.00.818, Patched Version=8.00.2271.  

I've looked at the MS site and am confused as to what I need to apply to get to the latest hotfixes.  All the numbers show less than the version I show.  I would appreciate help in checking what versions I have and understanding what I need to apply to be at the latest patches.

Question by:okcuser
  • 2
  • 2

Author Comment

ID: 22922642
When I run on the server:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
I get:
8.00.2187, SP4, Standard Edition
LVL 12

Expert Comment

by:Nathan Riley
ID: 22922750
I believe the newest version is 8.00.384

Accepted Solution

okcuser earned 0 total points
ID: 22922921
so where do I find it?  According to the documentation I was sent with the audit, the latest service pack for SQL Sever 2000 is sp4 _ Q946584 Hotfix (version 8.00.2271).  But when I look on the MS website, I can't find where you can download that hotfix.
LVL 12

Expert Comment

by:Nathan Riley
ID: 22943264
Yep I just found that, you have to request it.  Otherwise you are the most current.  Are all the clients current that are connecting to the server?

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

810 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