PRB: An Access Violation Occurs If the Sqlsort.dll Version Is Not Compatible with the SQL Server Version (327424)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q327424

SYMPTOMS

You receive one of the following error messages:
  • When you connect to SQL Server 7.0 from SQL Server Enterprise Manager:
    A connection could not be established to <ServerName>.
    Reason: SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
    Please verify SQL Server is running and check your SQL Server registration properties (by right-clicking on the ServerName node) and try again.
    -Or-
  • When you click Alerts under SQL Server Agent in SQL Server Enterprise Manager:
    Error O: SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Additionally, the Errorlog file in SQL Server 7.0 contains one of the following stack dumps: 

SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. 
SQL Server is terminating this process.
.
*******************************************************************************
*
* BEGIN STACK DUMP:
*   0x/xx/02 03:12:54 spid 7
*
*   Exception Address = 04004697 (Ordinal6 + 297)
*   Exception Code    = c0000005 E
*   Access Violation occurred writing address 00000004
* Input Buffer 54 bytes -
*  e x e c   s p _ M S d b u s e r p r i v   N ' v e r ' 
* 
...
-------
Short Stack Dump
0x04004697 Module(sqlsort+4697) (Ordinal6+297)
0x005bea83 Module(sqlservr+1bea83) (GetUnicodeRange+e7)
0x00575825 Module(sqlservr+175825) (CLikeRangeUtil::LikeRangeTransW+2ec)
0x00647680 Module(sqlservr+247680) (CXVariant::LikeRangeStart+7b)
0x0056d35b Module(sqlservr+16d35b) (COptExpr::PexprFoldMain+103c)
0x00443d71 Module(sqlservr+43d71) (COptExpr::PexprFoldMain+b8)
0x00443c08 Module(sqlservr+43c08) (COptExpr::PexprFold+3f)
0x004e0d3b Module(sqlservr+e0d3b) (CCvtTree::BuildSte+12e)
0x004e0c15 Module(sqlservr+e0c15) (BuildSteFromTree+39)
0x004e0b97 Module(sqlservr+e0b97) (CStmtCond::Init+4e)
0x00438530 Module(sqlservr+38530) (CCompPlan::FCompileStep+f23)
0x0043d00f Module(sqlservr+3d00f) (CProchdr::FCompile+5d9)
0x0040ec53 Module(sqlservr+ec53) (CSQLSource::FTransform+234)
0x0042140c Module(sqlservr+2140c) (CSQLObject::FTransform2+1ab)
0x004e1cdc Module(sqlservr+e1cdc) (CSQLObject::FGetFromDisk+627)
0x00420f96 Module(sqlservr+20f96) (CSQLObject::FTransform+21a)
0x0040e7b9 Module(sqlservr+e7b9) (CSQLSource::Execute+11d)
0x0046225f Module(sqlservr+6225f) (CStmtExec::XretLocalExec+127)
0x0046211e Module(sqlservr+6211e) (CStmtExec::XretExecute+253)
0x0040f487 Module(sqlservr+f487) (CMsqlExecContext::ExecuteStmts+11b)
0x0040ef35 Module(sqlservr+ef35) (CMsqlExecContext::Execute+16b)
---------------------------------------------------------------------------
Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.
-Or- 

*******************************************************************************
*
* BEGIN STACK DUMP:
*   0x/xx/02 16:49:07 spid 7
*
*   Exception Address = 105B498A
*   Exception Code    = c0000005 E
*   Access Violation occurred reading address FFFFFFFF
* Input Buffer 54 bytes -
*  e x e c   s p _ M S d b u s e r p r i v   N ' v e r ' 
.........
Short Stack Dump
0x105b498a Module(UNKNOWN+0)
---------------------------------------------------------------------------

Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.

***************************************************************************
*
* BEGIN STACK DUMP:
*   0x/xx/02 16:47:50 spid 7
*
*   Exception Address = 105B48FA
*   Exception Code    = c0000096 E
* Input Buffer 188 bytes -
*  E X E C U T E   m s d b . d b o . s p _ h e l p _ a l e r t   @ o r d e 
*  r _ b y   =   N ' s e v e r i t y   A S C ,   m e s s a g e _ i d   A S 
*  C ,   d a t a b a s e _ n a m e   D E S C ' 
*
---------------------------------------------------------------------------
Short Stack Dump
0x105b48fa Module(UNKNOWN+0)
---------------------------------------------------------------------------

Error: 0, Severity: 19, State: 0
language_exec: Process 7 generated an access violation. SQL Server is terminating this process.

CAUSE

This behavior occurs if the versions of Sqlsort.dll and Sqlservr.exe are not compatible.

RESOLUTION

To resolve this behavior, make sure that the version of Sqlsort.dll is compatible with your version of SQL Server 7.0. For additional information about how to determine the version of the existing SQL Server 7.0 build, click the article number below to view the article in the Microsoft Knowledge Base:

321185 HOW TO: Identify Your SQL Server Service Pack Version and Edition

After you verify the version of SQL Server 7.0, verify the version of Sqlsort.dll to make sure that it is compatible (to verify compatibility, look at the following table). This .dll file is located in the MSSQL7\binn folder.

Sqlsort.dll is included in SQL Server 7.0 SP3 and later, in the post-SQL 7.0 SP3 security update, and in other fixes. The following table summarizes the Sqlsort.dll file version and the matching Sqlservr.exe file version. If you experience the symptoms in this article, use the table to identify and to replace the Sqlsort.dll file with the correct version.

Sqlsort.dll File VersionCompatible Sqlservr.exe File VersionRelated Article
7.00.9617.00.961

274797 INF: SQL Server 7.0 Service Pack 3 Fix list

7.00.9787.00.978

285870 FIX: Update With Self Join May Update Incorrect Number Of Rows

7.00.9787.00.996

299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have

318053 FIX: The EXCEPTION_FLT_INVALID_OPERATION Error Occurs During a Query Compilation

7.00.978 7.00.1004

308126 FIX: Error 2627 May Cause Sysindexes.rowcnt Field to Be Decremented

7.00.09787.00.1012

311000 FIX: ODBC Functions TIMESTAMPADD and TIMESTAMPDIFF May Cause Error 128

7.00.09787.00.1016

314117 FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr

7.00.09787.00.1020

304851 FIX: SQL Server Text Formatting Functions Contain Unchecked Buffers

7.00.9947.00.994

298643 FIX: Poor Cardinality Estimate for Tables with Multiple Qualifying Histogram Values

7.00.10217.00.1021

317979 FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source

7.00.10217.00.1028

319507 FIX: SQL Extended Procedure Functions Contain Unchecked Buffers

7.00.10217.00.1026 (SP3-based) or 7.00.1071 (SP4-based)

319851 FIX: Assertion and Error Message 3314 Occurs If You Try to Roll Back a Text Operation with READ UNCOMMITTED

7.00.10217.00.1033

324469 FIX: Error Message 9004 May Occur When You Restore a Log That Does Not Contain Any Transactions

7.00.1063 7.00.1063 SQL Server 7.0 Service Pack 4

MORE INFORMATION

The following stored procedure runs when you connect to SQL Server 7.0 from SQL Server Enterprise Manager: 
EXEC sp_MSdbuserpriv  N'ver'
The following stored procedure runs when you click Alerts under SQL Server Agent in SQL Server Enterprise Manager: 
EXEC msdb.dbo.sp_help_alert  @order_by  =  N'severity ASC, message_id ASC, database_name DESC'
NOTE: When you run these stored procedures in SQL Query Analyzer, a similar access violation occurs:
ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Modification Type:MajorLast Reviewed:10/23/2002
Keywords:kbprb KB327424 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.