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