Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Setup / June 2005

Tip: Looking for answers? Try searching our database.

Still showing older version after SP3a install

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cables - 27 Jun 2005 19:58 GMT
To resolve the security issue described in MS Security Bulletin MS02-061
(Q316333) the article stated I needed to update my installation of SQL Server
2000 to SP2.  The article also stated, "All of the changes included in the
re-released bulletin are included in SQL Server 2000 SP3a and MSDE 2000 SP3a.
Based on this information I downloaded and installed SQL 2000 Server SP3a
via the instructions found at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=90dcd52c-0488-4e46-afbf
-acace5369fa3&DisplayLang=en


Logged in as the local administrator I Installed Database Components SP3a
(SQL2KSP3.exe), then Analysis Services Components SP3a (SQL2KASP3.exe).  I
then rebooted the server (even though I was not prompted to).  After the
successful reboot, I logged back in (as the local administrator) and
installed SQL Server 2000 Desktop Engine (MSDE) (SQL2kdesksp3.exe).  I then
successfully rebooted the server again.  After the reboot  I ran the SQL
command to determine the installed version of SQL Server (from MS
Knowledgebase Article #321185).  The output reported an outdated version (the
same version as before I ran the executables).  The command reports I'm
running the following version:

RTM   2000.80.194.0

It should be noted that when running all three executables all three
completed with a notification of successful completion.  Also, none of the
executables prompted me to reboot (or for anything else for that matter).

Did I do something wrong?  Am I missing something?  Or is that command just
giving me bogus output?

Please help!!

Cables
Keith Kratochvil - 28 Jun 2005 12:36 GMT
After extracting the service packs that you downloaded from the web did you
run them?  Simply double-clicking on them just extracts them.  Once the
files have been extracted you need to install the service pack.  Follow the
directions within the readme to do so

Signature

Keith

> To resolve the security issue described in MS Security Bulletin MS02-061
> (Q316333) the article stated I needed to update my installation of SQL
[quoted text clipped - 33 lines]
>
> Cables
Cables - 28 Jun 2005 17:16 GMT
> After extracting the service packs that you downloaded from the web did you
> run them?  Simply double-clicking on them just extracts them.  Once the
[quoted text clipped - 40 lines]
>
> I was not prompted for a location for an 'extraction'.  Where would the files be extracted to by default??
Keith Kratochvil - 28 Jun 2005 17:24 GMT
C:\sql2ksp3

Signature

Keith

I was not prompted for a location for an 'extraction'.  Where would the
files be extracted to by default??
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.