How to obtain the latest service pack for SQL Server 2005

Article translations Article translations
Article ID: 913089 - View products that this article applies to.
Expand all | Collapse all

On This Page

INTRODUCTION

Microsoft distributes fixes in service packs. Service packs keep a product current. They include hotfixes and software updates. Service packs may also include system administration tools, drivers, and additional components. These updates and components are conveniently bundled for easy downloading.

Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. You do not have to install a previous service pack before you install the latest one. For example, you do not have to install Microsoft SQL Server 2005 Service Pack 1 (SP1) before you install Microsoft SQL Server 2005 Service Pack 2 (SP2).

MORE INFORMATION

Microsoft SQL Server 2005 Service Pack 4

Release date: December 17, 2010

How to obtain

To obtain SQL Server 2005 SP4, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkID=204632
To obtain SQL Server 2005 Express Edition SP4, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkID=204633

Fix list

For a list of the bugs that are fixed in SQL Server 2005 SP4, click the following article number to view the article in the Microsoft Knowledge Base:
2463332 List of the bugs that are fixed in SQL Server 2005 Service Pack 4

Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP4, the installation is unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update upgrades all instances of SQL Server 2005 to SQL Server 2005 SP4. For example, if you have two instances of SQL Server 2005 that are running on the computer, both instances are upgraded to SQL Server 2005 SP4.
  • The SQL Server 2005 Express Edition updates are shown when you do an express scan and are available as an automatic update. The other editions of SQL Server are available as a custom update or as an optional update.
  • For more information about Microsoft Update, visit the following Microsoft Web site:
    http://update.microsoft.com/microsoftupdate/v6/about.aspx

List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 SP4, refer to Microsoft SQL Server 2005 SP4 Release Notes. To read them, visit the following Microsoft Web site:
http://go.microsoft.com/?LInkID=9749584

Readme

To read the readme files for SQL Server 2005 SP4, visit the following Microsoft Web site:
http://go.microsoft.com/?LinkID=9749571

Microsoft SQL Server 2005 Service Pack 3

Release date: December 15, 2008

How to obtain

To obtain SQL Server 2005 SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135960
To obtain SQL Server 2005 Feature Pack December 2008, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135971
To obtain SQL Server 2005 Express Edition SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135970
To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135973
To obtain SQL Server 2005 Express Edition Toolkit SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=135974

Fix list

For a list of the bugs that are fixed in SQL Server 2005 SP3, click the following article number to view the article in the Microsoft Knowledge Base:
955706 A list of the bugs that are fixed in SQL Server 2005 Service Pack 3

Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP3, the installation is unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update upgrades all instances of SQL Server 2005 to SQL Server 2005 SP3. For example, if you have two instances of SQL Server 2005 that are running on the computer, both instances are upgraded to SQL Server 2005 SP3.
  • The SQL Server 2005 Express Edition updates are shown when you do an express scan and are available as an automatic update. The other editions of SQL Server are available as a custom update or as an optional update.
  • For more information about Microsoft Update, visit the following Microsoft Web site:
    http://update.microsoft.com/microsoftupdate/v6/about.aspx

List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 SP3, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=131442

Readme

There are several different readme files for SQL Server 2005 SP3. To read them, visit the following Microsoft Web site:
http://go.microsoft.com/fwlink/?LinkId=130542

Microsoft SQL Server 2005 Service Pack 2

Release date: March 5, 2007

How to obtain

To obtain SQL Server 2005 SP2 for all editions of SQL Server 2005 in an automated way, visit the following Microsoft Update Web site. (These editons include Microsoft SQL Server 2005 Express Edition.)
http://update.microsoft.com
To obtain SQL Server 2005 SP2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a
To obtain SQL Server 2005 Express Edition SP2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=31711d5d-725c-4afa-9d65-e4465cdff1e7
To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=5b5528b9-13e1-4db9-a3fc-82116d598c3d
To obtain Windows Internal Database x86 (WYukon SP2 x86), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=30A7365B-91C5-4C28-85A5-9AB861168C0E&displaylang=en
To obtain Windows Internal Database x64 (WYukon SP2 x64), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=DE6B898B-1E59-4571-A301-D26FB39D6D9F&displaylang=en

Fix list

For a list of the bugs that are fixed in SQL Server 2005 SP2, click the following article number to view the article in the Microsoft Knowledge Base:
921896 A list of the bugs that are fixed in SQL Server 2005 Service Pack 2

Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP2, the installation will be unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update will upgrade all instances of SQL Server 2005 to SQL Server 2005 SP2. For example, if you have two instances of SQL Server 2005 running on your computer, both instances will be upgraded to SQL Server 2005 SP2.
  • The SQL Server 2005 Express updates will be shown when you do an express scan and will be available as an automatic update. The other editions of SQL Server will be available as a custom update or as an optional update.
  • For more information about Microsoft Update, visit the following Microsoft Web site:
    http://update.microsoft.com/microsoftupdate/v6/about.aspx

List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 SP2, visit the following Microsoft Web site:
http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm

Readme

There are several different readme files for SQL Server 2005 SP2. To read them, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=eb05d099-8a66-45f6-84ce-4888760d2af8

Microsoft SQL Server 2005 Service Pack 1

Release date: March 18, 2006

How to obtain

To obtain SQL Server 2005 SP1, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CB6C71EA-D649-47FF-9176-E7CAC58FD4BC
To obtain Microsoft SQL Server 2005 Express Edition SP1, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=11350B1F-8F44-4DB6-B542-4A4B869C2FF1
To obtain Microsoft SQL Server 2005 Express Edition with Advanced Services SP1, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=4c6ba9fd-319a-4887-bc75-3b02b5e48a40

Microsoft Update

To obtain SQL Server 2005 SP1 from Microsoft Update, visit the following Microsoft Web site:
http://update.microsoft.com

Important notes for using Microsoft Update

  • When you use Microsoft Update to install SQL Server 2005 SP1, the installation will be unattended, unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
  • Microsoft Update will upgrade all instances of SQL Server 2005 to SQL Server 2005 SP1. For example, if you have two instances of SQL Server 2005 running on your computer, both instances will be upgraded to SQL Server 2005 SP1.
  • If you are running SQL Server 2005 on a beta edition of Microsoft Windows Vista, use the download center link to upgrade to SQL Server 2005 SP1. If you try to upgrade to SQL Server 2005 SP1 by using Microsoft Update, you may experience an error that says the certificate is invalid.
SQL Server 2005 Express Edition SP1 is not available from Microsoft Update.

Fix list

For a list of bugs that are fixed in SQL Server 2005 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
913090 A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1

List of new features and improvements

For more information about the new features and improvements in SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
916940 A list of the new features and improvements that are included in SQL Server 2005 Service Pack 1

Readme

There are several different readme files for SQL Server 2005 SP1. To read them, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=b0167129-5ac8-49c4-90bd-0493f3773081

Additional releases

Additional releases are available for SQL Server.

Microsoft SQL Server 2005 Express Edition with Advanced Services

Microsoft SQL Server 2005 Express Edition with Advanced Services is a new, free, and easy-to-use version of SQL Server Express. SQL Server 2005 Express Edition with Advanced Services includes more features and makes it easier than ever to start developing powerful data-driven applications for Web development or for local desktop development.

To obtain SQL Server 2005 Express Edition with Advanced Services, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=4C6BA9FD-319A-4887-BC75-3B02B5E48A40

Microsoft SQL Server 2005 Express Edition Toolkit

Microsoft SQL Server 2005 Express Edition Toolkit provides additional tools and resources for SQL Server 2005 Express Edition and for SQL Server 2005 Express Edition with Advanced Services.

To obtain SQL Server 2005 Express Edition Toolkit, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=3C856B93-369F-4C6F-9357-C35384179543

Microsoft SQL Server Management Studio Express (SSMSE)

Microsoft SQL Server Management Studio Express (SSMSE) is a free and easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.

To obtain SQL Server Management Studio Express (SSMSE), visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
Note Readme files are available for SQL Server 2005 Express Edition with Advanced Services, for SQL Server 2005 Express Edition Toolkit, and for SQL Server Management Studio Express:
  • ReadmeSSMSE.htm: Readme for SQL Server Management Studio Express
  • ReadmeSQLEXP2005Advanced.htm: Readme for SQL Server 2005 Express Edition with Advanced Services
  • ReadmeSQLEXP2005Toolkit.htm: Readme for SQL Server 2005 Express Edition Toolkit

Properties

Article ID: 913089 - Last Review: December 18, 2010 - Revision: 14.0
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
Keywords: 
kbgetsp kbservicepack kbexpertiseinter kbexpertiseadvanced kbtshoot kbinfo KB913089

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com