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

View products that this article applies to.

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

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.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 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
Source: MSSQLSERVER
DESC: 17310:
FRunCm: Process 2844 gen fatal except c0000005
EXCEPTION_ACCESS_VIOLATION.
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.

Back to the top

RESOLUTION

There are three options for resolving this issue:

Back to the top

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 (http://support.microsoft.com/kb/290211/EN-US/ ) INF: How to Obtain the Latest SQL Server 2000 Service Pack

Back to the top

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
Note The SQLRedis.exe file is located in the \x86\Other folder in the installation directory.
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.

Back to the top