Microsoft SQL Server 2005 SP4 Release Notes

Microsoft SQL Server 2005 SP4 Release Notes

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.

Contents

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.

[Top]


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.

[Top]


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.

[Top]


© 2010 Microsoft Corporation. All rights reserved.

Sort by: Published Date | Most Recent | Most Useful
Comments
  • You need to be more specific about the VS 2005 SP1 requirement. VS2005 is installed with SQL2005 (pieces of it at least). It is this component that needs to be updated to SP1 to install SP4 right?

    For a Client Tools install is VS2005 SP1 also needed?

    Thanks

    Chris

  • Chris,

    We clarified above that you need to update VS2005 to include SP1. So the first answer is "yes." We're verifying the second question. Thanks!

    Ed Price

    SQL Server

  • Ed,

    Aaron Bertrand sqlblog.com/.../sql-server-2005-sp4-is-here.aspx mentioned that he had installed SP4 without the VS2005 update beforehand. What does SP4 need that is in VS2005 SP1?

    Thanks

    Chris

  • If there is a prerequisite to install VS 2005 SP1 prior to the installation of SQL2005/SP4, it would be very handy to have a link to that download site where this prerequisite is mentioned.

  • LindaLF_1, I added the link to VS 2005 SP1. Thank you for your feedback.

    ChrisAVWood, I will verify the answer to your question. Thanks!

    Ed Price, SQL Server

  • After further investigation, the note "Install Visual Studio 2005 SP1" was first submitted by a customer and included very specific circumstances that we don't think are applicable to enough customers. We removed the note. Thank you for your feedback.

  • Hi, question: what is the 'revert' option upon there is any need to revert the SP4 installation to the previous version. Current version/patch in my environment is SP3. Cheers

  • melvynt,

    I need to clarify your question. Are you asking how to revert to the previous version?

    Thank you!

    Ed Price, Microsoft Technical Writer

  • Hi Ed,

    Just want to check if its ok to upgrade SQL Server 2005 from SP3 to SP4 for  MOSS 2007 and MS CRM Dynamics 4.0 application server?

  • What isn't specified is that the Service Pack requires that the SQL Server Browser service is started.  As part of the security reccomendations this service is Stopped and Disabled on our environments.  And the errors logged were not helpful at all either.

    All sorted though.  After starting the Browser the Service Pack installed.

Page 1 of 1 (10 items)