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
The multimedia timer frequency does not increase when you use Windows Internal Database.
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.
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:
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:
Click Start, type msconfig in the Start Search box, and then press ENTER.
If you are prompted for an administrator password or for confirmation, type the password or click Continue.
On the General tab, click Selective Startup.
Under Selective Startup, clear the Load Startup Items check box.
Click the Services tab, click to select the Hide All Microsoft Services check box, and then click Disable All.
When you are prompted, click Restart.
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
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.
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