Article ID: 814572
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 2000 Service Pack 3
SYMPTOMS
After you install Microsoft SQL Server 2000 Service Pack 3 (SP3), Microsoft SQL Server does not start or it starts and then immediately stops, and error messages are logged in various files.
For example, SQL Server generates the following access violation in the SQL Server error log file:
(Note The following errors are samples.)
The following error is generated in the Application log in Event Viewer:
The following text is generated in the SQL Server 2000 SP3 Setup log file ( Sqlsp.log ):
The following text is generated in the SP3_serv_uni.out file. This file is in the \Program Files\Microsoft SQL Server\MSSQL\Install folder.
RESOLUTION
There are three options for resolving this issue:
Option 1
This issue is resolved in SQL Server 2000 Service Pack 3a (SP3a).
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Option 2
Note Run the following commands from the SP3 installation CD or installation directory. In the following procedure, the installation directory is C:\sql2ksp3
.
- From a command prompt, run the following command to extract files from the cabinet self-extractor file, SQLRedis.exe, to the C:\Extract folder:
C:\sql2ksp3\x86\other\sqlredis.exe /T:C:\Extract /C
- Locate the Mdac_qfe.exe file in the C:\Extract folder, and then run the Mdac_qfe.exe file.
- The Microsoft Data Access Components Hotfix Installer dialog box opens and indicates that you are installing a hotfix. Click OK to continue with the hotfix installation.
- After you successfully install the MDAC hotfix (Mdac_qfe.exe), run SQL Server 2000 SP3 Setup again to successfully complete the installation.
Option 3
If the first two options do not resolve the issue, please contact Microsoft Product Support Services.
Keywords: kberrmsg kbupgrade kbsysadmin kbprb KB814572