|
|
 Microsoft SQL Server 2000 Service Pack 3aBrief DescriptionDownload SQL Server 2000 Service Pack 3a (SP3a), the latest and most comprehensive update to SQL Server 2000 that corrects vulnerabilities including the Slammer (W32.slammer) virus. On This PageQuick Details| Version: | 8.00.0760.09 | | Date Published: | 2/6/2009 | | Language: | English | | Download Size: | 43.6 MB - 167.9 MB* | | *Download size depends on selected download components. |
| | Change Language: | |
OverviewIf you have applied SP3, you do not need to apply SP3a. SP3a is primarily
intended for SQL Server users who have not applied any versions of SP3 and for
MSDE users who want to choose the new "disable network protocols" option.
Additionally, you should use SP3a rather than SP3 moving forward. For more
information see: http://www.microsoft.com/sql/downloads/2000/sp3.asp.
Database Components
Downloadable file name: SQL2KSP3.exe SP3a.
Updates for the database components of SQL Server 2000 include:
-
Data engine.
Database client utilities, such as SQL Server Enterprise Manager and osql for
SQL Server 2000.
-
Database client connectivity components, such as the OLE DB Provider for SQL
Server, the SQL Server Open Database Connectivity (ODBC) driver, and the client
Net-Libraries.
Analysis Services Components
Downloadable file name: SQL2KASP3.exe SP3a.
Updates for the Analysis Services components of SQL Server 2000 include:
-
Analysis Services engine. Analysis Services client components, such as Analysis
Manager and the OLE DB Provider for Analysis Services.
-
Database client connectivity components, such as the OLE DB Provider for SQL
Server, the SQL Server ODBC driver, and the client Net-Libraries.
SQL Server 2000 Desktop Engine(MSDE)
Downloadable file name: SQL2kdesksp3.exe SP3a.
SP3a updates for MSDE include updates and new installations for the database
components of instances of the SQL Server 2000 Desktop Engine, including:
-
The Desktop data engine.
-
Database client connectivity components, such as the OLE DB Provider for SQL
Server, the SQL Server ODBC driver, and the client Net-Libraries.
SQL2kdesksp3.exe includes all of the files that are required to install a new
instance of Desktop Engine (.msi files), to upgrade all existing instances of
Desktop Engine (.msp files), as well as to consume merge modules (.msm files)
into applications. You can install the three parts of SP3a described above
individually. However, if you want to upgrade both your database components and
Analysis Services components, you must apply both the SP3a database components
and the SP3a Analysis Services components.
Note:
-
SQL 2000 Servers infected by the "Slammer" worm virus should follow
instructions on the Microsoft TechNet Web site before installing SP3a.
-
SQL Server 2000 SP3a contains an additional fix to English Query that you will
need to apply separately. For additional information about this fix, see the
article "FIX: Potential English Query Security Issue" in the Microsoft
Knowledge Base.
For More Information
For more information on SQL Server 2000 SP3a, click the links in the Related
Resources box.
 Top of page
System Requirements- Supported Operating Systems: Windows 2000; Windows 98; Windows ME; Windows NT; Windows Server 2003; Windows XP
- Supported Operating Systems: Windows 2000, Windows 98, Windows ME, Windows NT,
Windows Server 2003, Windows XP
- PC with Intel or compatible Pentium 166 MHz or higher processor
- Microsoft Windows NT Workstation 4.0 with Service Pack 5 or later, Windows NT
Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise
Edition with Service Pack 5 or later, Windows 2000 Professional, Windows 2000
Server, Windows 2000 Advanced Server, Windows 2000 Datacenter Server, or
Windows XP with Service Pack 1 or later operating system
- Minimum of 64 MB of RAM (128 MB or more recommended)
- 95-270 MB for server; approximately 250 MB for typical installation
- 50 MB minimum for Analysis Services; 130 MB for typical installation
- 80 MB for Microsoft English Query (supported on Windows 2000 operating systems
but not logo certified)
- Microsoft Internet Explorer 5.0 or later
- VGA or higher resolution monitor
- Microsoft Mouse or compatible pointing device
Top of page InstructionsTo install SP3a, follow the installation instructions below. Not all steps are
required, depending on which of the following SQL Server 2000 components or
configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft® Windows®
XP to Windows XP Service Pack 1 before applying SQL Server 2000 Service Pack
3a.
- Back up your SQL Server databases.
- Back up your Analysis Services databases.
- Make sure that the system databases have enough free space.
- Minimum of 64 MB of RAM (128 MB or more recommended)
- Install Database Components SP3a (SQL2KSP3.exe).
- Install Analysis Services Components SP3a (SQL2KASP3.exe).
- Restart services and applications.
More detailed instructions can be found at the
Product Support Services Readme . Top of page Additional Information Top of page Files in This DownloadThe links in this section correspond to separate files available in this download. Download the files most appropriate for you. Top of page Top of page What Others Are Downloading Top of page
|
