Servers

    Microsoft SQL Server 2000 Service Pack 3a

    Select Language:
    Download 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.
    • Note:There are multiple files available for this download.Once you click on the "Download" button, you will be prompted to select the files you need.
      Version:

      8.00.0760.09

      File Name:

      sql2ksp3.exe

      sql2kasp3.exe

      sql2kdesksp3.exe

      Date Published:

      2/6/2009

      File Size:

      55.1 MB

      43.6 MB

      69.2 MB

        If 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.
    • Supported Operating System

      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

    • Install Instructions
        To 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.

        1. Back up your SQL Server databases.
        2. Back up your Analysis Services databases.
        3. Make sure that the system databases have enough free space.
        4. Minimum of 64 MB of RAM (128 MB or more recommended)
        5. Install Database Components SP3a (SQL2KSP3.exe).
        6. Install Analysis Services Components SP3a (SQL2KASP3.exe).
        7. Restart services and applications.
        More detailed instructions can be found at the Product Support Services Readme .

    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial