Applies ToMicrosoft SQL Server 2005 Developer Edition Microsoft SQL Server 2005 Enterprise Edition 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 Standard Edition Microsoft SQL Server 2005 Standard X64 Edition Microsoft SQL Server 2005 Workgroup Edition

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 number

KB article number

Description

294192

2445326

FIX: 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

396531

980671

Correcting the lack of cryptographic salt variation on SQL Server sa login hash

308002

968749

SQL 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 number

Description

297747

The multimedia timer frequency does not increase when you use Windows Internal Database.

555409

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

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.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.