Microsoft KB Archive/327424

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

Article ID: 327424

Article Last Modified on 10/23/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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 .

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. . ... --- 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 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 '
 * 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 0x105b498a Module(UNKNOWN+0) ---
 * 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 '
 * 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 '

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

--- Short Stack Dump 0x105b48fa Module(UNKNOWN+0) ---
 * 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 '
 * 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 '

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.



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.

Additional query words: Access violation sqlsort.dll service pack build sp_MSdbuserpriv sqlservr.exe sp_help_alert AV 70

Keywords: kbnofix kbprb KB327424

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.