DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 913089 - Last Review: June 20, 2014 - Revision: 15.0

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 (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 (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  (http://support.microsoft.com/kb/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 (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 (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 (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 (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 (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 (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 (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 (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  (http://support.microsoft.com/kb/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 (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 (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 (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 (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 (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 (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 (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 (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 (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  (http://support.microsoft.com/kb/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 (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 (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 (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 (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 (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 (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 (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  (http://support.microsoft.com/kb/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  (http://support.microsoft.com/kb/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 (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 (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 (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 (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

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: 
kbsqlsetup kbgetsp kbservicepack kbexpertiseinter kbexpertiseadvanced kbtshoot kbinfo KB913089
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support