This site in other countries/regions:

Microsoft Download Center

Microsoft

Microsoft SQL Server 2005 Service Pack 2

Quick links

Download Service Pack 2 for Microsoft SQL Server 2005.

Quick details

Version: 1.0 Date published: 3/6/2007
KB articles: KB921896

Files in this download

The links in this section correspond to files available for this download. Download the files appropriate for you.

File name Size
SQLServer2005SP2-KB921896-IA64-ENU.exe 392.4 MB Download
SQLServer2005SP2-KB921896-x64-ENU.exe 339.4 MB Download
SQLServer2005SP2-KB921896-x86-ENU.exe 282.4 MB Download

Overview

Service Pack 2 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2. You can use these packages to upgrade any of the following SQL Server 2005 editions:

  • Enterprise
  • Enterprise Evaluation
  • Developer
  • Standard
  • Workgroup

Note: To upgrade SQL Server 2005 Express Edition, obtain the SP2 version of Express Edition or Express Edition with Advanced Services.

Note: SQL Server 2005 SP2 was refreshed on March 5th, 2007. For more information, see Knowledge Base article 933508.

For a list of new features and improvements that are included in SQL Server 2005 SP2, review the What's New document.

Top of pageTop of page

System requirements

Supported operating systems: Windows 2000 Service Pack 4, Windows Server 2003 Service Pack 1, Windows Vista, Windows XP Service Pack 2

  • 32-bit systems (x86)
    • PC with Intel or compatible Pentium III 600 MHz or higher processor (1 GHz or faster recommended)
  • 64-bit systems (x64, ia64)
    • 1GHz or faster processor
  • Minimum of 512 MB of RAM (1 GB or more recommended)
  • 675 MB of available hard disk space

Note: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn." For more information about installing and running SQL Server 2005 on Windows Vista and Windows Server "Longhorn," see this Microsoft Web site.

Top of pageTop of page

Instructions

Note: You must have administrative rights on the computer to install SQL Server 2005 SP2.

    Step 1: Download and review the setup documentation and readme file.

    Step 2: Download the appropriate package by clicking one of the links below. To start the installation immediately, click Run. To install SP2 at a later time, click Save.

Top of pageTop of page

Additional information


Top of pageTop of page