You are currently offline, waiting for your internet to reconnect

List of the issues that are fixed in SQL Server 2005 Service Pack 4

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

Summary
This article contains information about the issues that are fixed in Microsoft SQL Server 2005 Service Pack 4 (SP4).

Notes
  • Other fixes that are not documented may be included in the service pack.
  • This list will be updated when more articles are released.
More information

Download information

To obtain SQL Server 2005 SP4, use the following procedure:
  1. Navigate to Microsoft Update Catalog and search for KB2463332:

    http://catalog.update.microsoft.com/v7/site/Search.aspx?q=KB2463332
  2. Download the package that is relevant to your edition.
NoteService Pack 4 is the minimum requirement for upgrading your SQL Server 2005 instance to a SQL Server 2014 instance.

For more information about how to obtain SQL Server 2005 service packs, click the following article number to view the article in the Microsoft Knowledge Base:
913089 How to obtain the latest service pack for SQL Server 2005

Issues that are fixed in this service pack

For more information about the issues that are fixed in SQL Server 2005 Service Pack 4, click the following article numbers to view the articles in the Microsoft Knowledge Base:
VSTS bug numberKB article numberDescription
2941922445326FIX: 0xC02020A1, 0xC020902A, 0xC0202092, and 0xC0047038 errors may occur at the same time when you try to run an SSIS 2005 package if you use multi-character column delimiters in a Flat File source
396531980671Correcting the lack of cryptographic salt variation on SQL Server sa login hash
308002968749SQL Server 2005 setup fails when MSXML Core Services 6.0 Service Pack 2 has already been installed

Additional issues that are fixed in this service pack

Resolutions to the following issues are also included in SQL Server 2005 Service Pack 4:
VSTS bug numberDescription
297747The multimedia timer frequency does not increase when you use Windows Internal Database.
555409An access violation error may occur during the execution of Extended Stored Procedures under high stress conditions.
In addition to the fixes that are listed below, SQL Server 2005 SP4 contains the hotfixes that were included in cumulative update packages for SQL Server 2005 Service Pack 3 from cumulative update package 1 to cumulative update package 11.

For more information about the cumulative update packages for SQL Server 2005 Service Pack 3, click the following article number to view the article in the Microsoft Knowledge Base:
960598 The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released
Troubleshoot Windows update issues
You may also encounter the following issues when you try to install this update:
  • The update installation fails.
  • The system keeps reminding you to install this update although you already installed it.
  • The desktop does not load.
If you encounter one if the issues mentioned above, you may try the following methods.

Click here to view or hide detailed information
Method 1: Reset Windows Update components and then try updating your computer

To reset the Windows Update components automatically, click the Fix itbutton or link. Click Runin the File Downloaddialog box, and then follow the steps in the Fix it wizard.

Note this Fix it Solution has two modes Default and Aggressive. You should run the Fix it solution in Default mode and determine whether it resolves your problem with Windows Update before you run it in Aggressive mode.





Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
For more information about how to reset Windows Update components, visit the following Microsoft Website:
971058 How do I reset Windows Update components?
Method 2: Manually download the update from the download link and then install it in clean boot mode
We suggest you to install the updates in clean boot mode to avoid the interruption of non-Microsoft programs. To enter clean boot mode on a computer, follow these steps:
  1. Click Start, type msconfig in the Start Search box, and then press ENTER.
  2. If you are prompted for an administrator password or for confirmation, type the password or click Continue.
  3. On the General tab, click Selective Startup.
  4. Under Selective Startup, clear the Load Startup Items check box.
  5. Click the Services tab, click to select the Hide All Microsoft Services check box, and then click Disable All.
  6. Click OK.
  7. When you are prompted, click Restart.
  8. Try update your computer again.
For more information about this method, visit the following Microsoft Website:
331796 Perform a clean startup to determine whether background programs are interfering with your game or program
References
For more information about how to determine the current SQL Server version and edition, click the following article number to view the article in the Microsoft Knowledge Base:
321185 How to identify your SQL Server version and edition
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.
fixlist sql2005sp4 fix
Properties

Article ID: 2463332 - Last Review: 05/16/2016 03:42:00 - Revision: 9.0

Microsoft SQL Server 2005 Analysis Services, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Express Edition with Advanced Services, Microsoft SQL Server 2005 Reporting Services, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Workgroup Edition, Windows Internal Database

  • kbqfe kbfix kbsurveynew kbexpertiseadvanced kbcip KB2463332
Feedback