This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 474888 (SQL Server 8.0)
Microsoft distributes Microsoft SQL Server 2000 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2000 fix release.
This article describes the following about this hotfix release:
The issues that are fixed by the hotfix package
The prerequisites for applying the hotfix package
Whether you must restart the computer after you apply the hotfix package
Whether the hotfix package is replaced by any other hotfix package
Whether you must make any registry changes after you apply the hotfix package
The files that are contained in the hotfix package
When you try to apply a hotfix on a Microsoft SQL Server 2000-based computer that is configured as a Microsoft Cluster Service (MSCS) node, the hotfix installer may fail. This problem occurs when you use SQL Server Authentication. When this problem occurs, you may receive an error message that resembles the following:
An error in updating your system has occurred.
Additionally, the following messages may be logged in the hotfix installer log:
22.218: SQL DLL: Checking user authentication product instance MSSQLServer using SQL authentication 22.218: SQL DLL: Attempting to bring cluster service MSCS-SQL online 22.390: SQL DLL: User authentication was successful for product instance MSSQLServer 40.906: SQL DLL: User authentication was successful for product instance MSSQLServer on target <ServerName> 40.937: SQL DLL: User authentication was successful for product instance MSSQLServer on target <ServerName> 224.672: SQL DLL: Pre-script OSQL connection failed - continuing to wait for SQL service to become responsive to connection requests 229.828: SQL DLL: Pre-script OSQL connection failed - continuing to wait for SQL service to become responsive to connection requests 321.828: SQL DLL: Pre-script OSQL connection failed - continuing to wait for SQL service to become responsive to connection requests 326.828: SQL DLL: SQL Server not responsive prior to running script 326.828: SQL DLL: Attempting to stop service: MSSQLServer 329.828: SQL DLL: Successfully stopped service: MSSQLServer 329.828: DoInstallation: CustomizeCall failed : 0x643 330.797: SQL DLL: Callback Function EndInstallation 330.797: SQL DLL: Callback Function FailedInstallation 330.812: Fatal error during installation. 330.812: KB911678(ENU) installation did not complete. Select 'OK' to undo the changes that have been made. 330.812: Starting process: C:\WINDOWS\$SQLUninstallSQL2000-KB911678-v8.00.2175-x86-ENU$\spuninst\spuninst.exe /~ -q -z 331.078: Software Update Rollback has completed with return code 0x643. This rollback requires a reboot. 331.078: KB911678(ENU) installation did not complete.
For a list of all publicly released SQL Server 2000 post-service pack hotfixes, click the following article number to view the article in the Microsoft Knowledge Base:
894905 Cumulative list of the hotfixes that are available for SQL Server 2000 Service Pack 4
The installer does not install this hotfix correctly on x64-based systems. This installation issue occurs when the following conditions are true:
The system uses the Advanced Micro Devices (AMD) AMD64 processor architecture or the Intel Extended Memory 64 Technology (EM64T) processor architecture.
Note This issue does not occur on systems that use the Intel Itanium processor architecture.
The system is running a 64-bit version of the Microsoft Windows Server operating system.
The system is running a 32-bit version of SQL Server 2000.
We have corrected this installation issue in later builds of SQL Server 2000, starting with version 8.00.2244. When a customer who is running SQL Server 2000 on an x64-based system requests this hotfix, we will provide a build that includes this hotfix and that can be installed correctly on an x64-based system. The build that we provide will be version 8.00.2244 or a later version.
To resolve this problem, apply the cumulative hotfix package (Build 2187) for SQL Server 2000 Service Pack 4. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
916287 A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2187
To work around this problem, use Microsoft Windows Authentication.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates