FIX: SQL Server Does Not Start and an Access Violation Occurs After You Install SQL Server 2000 Service Pack 3

This article has been archived. It is offered "as is" and will no longer be updated.
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.)
2003-01-30 14:57:47.93 server Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQLDump0030.txt
2003-01-30 14:57:47.95 server FRunCM: Process 828 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
* 01/30/03 14:57:47 spid 0
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000

* -------------------------------------------------------------------------------
* Short Stack Dump
* 00000000 Module(sqlservr+FFC00000)
* 00A73EB0 Module(sqlservr+00673EB0) (g_umsControl+00000000)
* 00514B3F Module(sqlservr+00114B3F) (LoadDCOM+00000103)
* 00519566 Module(sqlservr+00119566) (FRunCM+00000475)
* 0051739E Module(sqlservr+0011739E) (initCM+00000064)
* 7800A27B Module(MSVCRT+0000A27B) (beginthread+000000CE)
* 77E8758A Module(KERNEL32+0000758A) (SetFilePointer+0000018A)
The following error is generated in the Application log in Event Viewer:
Event ID: 17055
DESC: 17310:
FRunCm: Process 2844 gen fatal except c0000005
SQL Server is terminating the process.
The following text is generated in the SQL Server 2000 SP3 Setup log file ( Sqlsp.log ):
22:08:34 Process Exit Code: (0)
22:08:34 C:\sql2ksp3\x86\BINN\osql.exe -Slpc:HCH_MEGA -b -n -d master -o "d:\Program Files\Microsoft SQL Server\MSSQL\install\sp3_serv_uni.out" -i "d:\Program Files\Microsoft SQL Server\MSSQL\install\sp3_serv_uni.sql" -Usa -P"
22:08:38 Process Exit Code: (1) 22:25:23 Error running script: sp3_serv_uni.sql (1)
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.
Creating 'system_function_schema.fn_get_sql'.
[DBNETLIB]ConnectionCheckForData (CheckforData()).
[DBNETLIB]General network error. Check your network documentation.
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.
  1. 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
    Note The SQLRedis.exe file is located in the \x86\Other folder in the installation directory.
  2. Locate the Mdac_qfe.exe file in the C:\Extract folder, and then run the Mdac_qfe.exe file.
  3. 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.
  4. 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.

Article ID: 814572 - Last Review: 12/08/2015 02:02:48 - Revision: 7.5

Microsoft SQL Server 2000 Service Pack 3

  • kbnosurvey kbarchive kberrmsg kbupgrade kbsysadmin kbprb KB814572