Click here to change the language.

This page is carefully and closely monitored. Any changes you make will be evaluated and then quickly accepted, refined, or reverted. Because this is a wiki, additions or refinements to these release notes might have been made by community members. To read the original and official release notes document, click here.


This Release Notes document describes known issues that you should read about before you install or troubleshoot Microsoft® SQL Server® 2005 Service Pack 4 (SP4). (Download SP4 here.) This document also provides search tips to help you find more known issues in Knowledge Base (KB) articles on the Microsoft Help and Support Web site. This Release Notes document and the KB articles supplement SQL Server 2005 Books Online.

This Release Notes document is available only online, not on the installation media, and it is updated periodically.

For information about how to get started with installing SQL Server 2005, see the SQL Server 2005 Readme. The Readme is available on the installation media and from the Readme download page.


2.0 Before You Install

1.0 What's New in Service Pack 4

For a list of the bugs that are fixed in SQL Server 2005 Service Pack 4 (SP4), see KB article 2463332. No new features or major changes were added to SP4.


2.0 Before You Install

Review the following known issue before you install SQL Server 2005 Service Pack 4 (SP4).  

2.1 Documentation Is Not Updated for SQL Server 2005 SP4

SQL Server 2005 Books Online and the SQL Server Help documentation have not been updated for the SP4 release, and you might find references to SP3 as the current or latest release.

2.2 How to Install Replication Components

Because SQL Server 2005 Books Online has not been updated, it provides instructions to install the replication components from the CD. However, once you upgrade SQL Server 2005 to SP2 or greater, you must install the replication components from the Add or remove programs page of Control Panel. In Windows 7, the Control Panel item is called Programs and Features.

To install SQL Server 2005 Replication Components in Windows Server 2008 and Windows 7

  1. On the computer that is running IIS, go to the Programs and Features page in Control Panel.
  2. Click Microsoft SQL Server 2005 to select it, and then click Change in the toolbar near the top of the page. The Microsoft SQL Server 2005 Maintenance dialog box opens.
  3. Select the instance that you want to include replication in, and then click Next.
  4. Select Database engine.
  5. Select Change installed components.
  6. Click Client Components, and then click Connectivity Components to install the SQL Server 2005 replication components.


3.0 How to Find More Known Issues

We recommend that you view more known issues by searching for a custom string on the Microsoft Support Web site or for "SQL Server 2005" on the Microsoft Support Web site

You can also join the SQL Server community to share your experiences and learn from other people who are using SQL Server 2005. For more information, see the SQL Server Community Web site.

Books Online is the primary documentation for SQL Server 2005. You can view SQL Server 2005 Books Online on TechNet, or download a stand-alone version from the SQL Server 2005 Books Online download page.


© 2010 Microsoft Corporation. All rights reserved.