Microsoft KB Archive/913089

= How to obtain the latest service pack for SQL Server 2005 =

Article ID: 913089

Article Last Modified on 11/20/2007

-

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

-



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).



Microsoft SQL Server 2005 Service Pack 2
Release date: 5 March 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

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: 18 March 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

Additional query words: sql2005sp1fix sql2005sp2fix

Keywords: kbinfo kbtshoot kbservicepack kbgetsp kbexpertiseadvanced kbexpertiseinter KB913089

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.