Re: "Not a valid user" crashes sql 7

From: David Treptow (david.treptow@chi.frb.org)
Date: 10/11/02


Date: Thu, 10 Oct 2002 17:34:45 -0500
From: David Treptow <david.treptow@chi.frb.org>


Yes, SQL Server actually stops. Here is the error log and the crash dump:

"Richard Waymire [MS]" wrote:

> When you say crash do you mean actually SQL Server the service is shut down?
> If so can you post your error log?
>
> --
> Richard Waymire, MCSE, MCDBA
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "David Treptow" <david.treptow@chi.frb.org> wrote in message
> news:3DA59181.2530F75F@chi.frb.org...
> > I am in the process of testing a new system running on Sql 7 SP4. We
> > are using integrated security, and when a user that has not been mapped
> > to the database tries to run the client program, it crashes sql server
> > on the host.
> >
> > In the dump file, I can see a message "Cannot open database requested in
> > login" (database name), "Login fails", "Login failed for user "
> > (username)
> >
> > Is there anything I can do so the crashes stop?
> >
> > Dave
> >



2002-10-07 18:52:25.27 kernel Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86)
        Apr 9 2002 14:18:16
        Copyright (c) 1988-2002 Microsoft Corporation
        Developer Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

2002-10-07 18:52:25.29 kernel Copyright (C) 1988-1997 Microsoft Corporation.
2002-10-07 18:52:25.29 kernel All rights reserved.
2002-10-07 18:52:25.29 kernel Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2002-10-07 18:52:25.35 kernel initconfig: Number of user connections limited to 32767.
2002-10-07 18:52:25.40 kernel SQL Server is starting at priority class 'normal'(1 CPU detected).
2002-10-07 18:52:25.52 kernel User Mode Scheduler configured for thread processing
2002-10-07 18:52:26.63 server Directory Size: 10793
2002-10-07 18:52:26.63 spid1 Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks
2002-10-07 18:52:26.76 spid1 Starting up database 'master'.
2002-10-07 18:52:26.92 spid1 Opening file C:\MSSQL7\data\master.mdf.
2002-10-07 18:52:27.02 spid1 Opening file C:\MSSQL7\data\mastlog.ldf.
2002-10-07 18:52:27.11 spid1 Loading SQL Server's Unicode collation.
2002-10-07 18:52:27.13 spid1 Loading SQL Server's non-Unicode sort order and character set.
2002-10-07 18:52:27.33 spid1 9 transactions rolled forward in database 'master' (1).
2002-10-07 18:52:27.35 spid1 0 transactions rolled back in database 'master' (1).
2002-10-07 18:52:27.48 spid1 Starting up database 'model'.
2002-10-07 18:52:27.48 spid1 Opening file C:\MSSQL7\DATA\model.mdf.
2002-10-07 18:52:27.55 spid1 Opening file c:\mssql7\data\modellog.ldf.
2002-10-07 18:52:27.63 spid1 Clearing tempdb database.
2002-10-07 18:52:27.67 spid1 Creating file C:\MSSQL7\DATA\TEMPDB.MDF.
2002-10-07 18:52:27.71 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2002-10-07 18:52:27.81 spid1 Creating file C:\MSSQL7\DATA\TEMPLOG.LDF.
2002-10-07 18:52:27.85 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2002-10-07 18:52:28.01 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2002-10-07 18:52:28.07 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2002-10-07 18:52:28.54 spid1 Closing file C:\MSSQL7\DATA\TEMPDB.MDF.
2002-10-07 18:52:28.63 spid1 Closing file C:\MSSQL7\DATA\TEMPLOG.LDF.
2002-10-07 18:52:28.73 spid1 Starting up database 'tempdb'.
2002-10-07 18:52:28.73 spid1 Opening file C:\MSSQL7\DATA\TEMPDB.MDF.
2002-10-07 18:52:28.77 spid1 Opening file C:\MSSQL7\DATA\TEMPLOG.LDF.
2002-10-07 18:52:29.02 spid1 Server name is 'G5MWWS54_R'.
2002-10-07 18:52:29.02 kernel Using 'SQLEVN70.DLL' version '7.00.1063'.
2002-10-07 18:52:29.02 kernel Using 'OPENDS60.DLL' version '7.00.00.1063'.
2002-10-07 18:52:29.08 ods Using 'SSNMPN70.DLL' version '7.0.694' to listen on '\\.\pipe\sql\query'.
2002-10-07 18:52:29.08 ods Using 'SSMSRP70.DLL' version '7.0.961' to listen on 'G5MWWS54_R'.
2002-10-07 18:52:29.38 ods Using 'SSMSSO70.DLL' version '7.0.1063' to listen on '1433'.
2002-10-07 18:52:29.40 spid6 Starting up database 'msdb'.
2002-10-07 18:52:29.41 spid6 Opening file C:\MSSQL7\DATA\msdbdata.mdf.
2002-10-07 18:52:29.41 spid7 Starting up database 'pubs'.
2002-10-07 18:52:29.41 spid7 Opening file C:\MSSQL7\DATA\pubs.mdf.
2002-10-07 18:52:29.41 spid8 Starting up database 'Northwind'.
2002-10-07 18:52:29.41 spid8 Opening file C:\MSSQL7\DATA\northwnd.mdf.
2002-10-07 18:52:29.41 spid9 Starting up database 'biffle'.
2002-10-07 18:52:29.41 spid9 Opening file c:\mssql7\data\biffle_data.mdf.
2002-10-07 18:52:29.61 spid6 Opening file c:\mssql7\DATA\msdblog.ldf.
2002-10-07 18:52:29.62 spid7 Opening file c:\mssql7\DATA\pubs_log.ldf.
2002-10-07 18:52:29.63 spid8 Opening file C:\MSSQL7\DATA\northwnd.ldf.
2002-10-07 18:52:29.68 spid9 Opening file C:\MSSQL7\data\Biffle_Log.LDF.
2002-10-07 18:52:30.74 spid6 Starting up database 'EmpStats'.
2002-10-07 18:52:30.74 spid6 Opening file C:\MSSQL7\DATA\EmpStats.mdf.
2002-10-07 18:52:31.20 spid6 Opening file C:\MSSQL7\DATA\EmpStats.ldf.
2002-10-07 18:52:33.57 spid6 27 transactions rolled forward in database 'EmpStats' (8).
2002-10-07 18:52:33.72 spid6 0 transactions rolled back in database 'EmpStats' (8).
2002-10-07 18:52:34.62 spid6 Closing file C:\MSSQL7\DATA\EmpStats.mdf.
2002-10-07 18:52:34.90 spid6 Closing file C:\MSSQL7\DATA\EmpStats.ldf.
2002-10-07 18:52:35.52 spid1 Recovery complete.
2002-10-07 18:52:36.28 spid1 SQL Server's Unicode collation is:
2002-10-07 18:52:36.28 spid1 'English' (ID = 1033).
2002-10-07 18:52:36.28 spid1 comparison style = 196609.
2002-10-07 18:52:36.28 spid1 SQL Server's non-Unicode sort order is:
2002-10-07 18:52:36.28 spid1 'nocase_iso' (ID = 52).
2002-10-07 18:52:36.28 spid1 SQL Server's non-Unicode character set is:
2002-10-07 18:52:36.28 spid1 'iso_1' (ID = 1).
2002-10-07 18:53:33.88 spid7 Starting up database 'EmpStats'.
2002-10-07 18:53:33.88 spid7 Opening file C:\MSSQL7\DATA\EmpStats.mdf.
2002-10-07 18:53:33.96 spid7 Opening file C:\MSSQL7\DATA\EmpStats.ldf.
2002-10-07 18:57:47.17 spid6 Closing file C:\MSSQL7\DATA\EmpStats.mdf.
2002-10-07 18:57:47.30 spid6 Closing file C:\MSSQL7\DATA\EmpStats.ldf.
2002-10-08 06:01:46.06 spid7 Starting up database 'EmpStats'.
2002-10-08 06:01:46.06 spid7 Opening file C:\MSSQL7\DATA\EmpStats.mdf.
2002-10-08 06:01:46.41 spid7 Opening file C:\MSSQL7\DATA\EmpStats.ldf.
2002-10-10 05:28:53.28 spid7 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 7, PSS = 0x2060f0d8, EC = 0x2060f288
Stack Dump being sent to C:\MSSQL7\log\SQL00003.dmp
*******************************************************************************
*
* BEGIN STACK DUMP:
* 10/10/02 05:28:58 spid 7
*
* Input Buffer 166 bytes -
* p h V
* j
* ~ c6 G 3 H A M I L T O N J o b T a s k B a
* r ( l o c a l ) O L E D B E m p S t a t s
*
*******************************************************************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a6b Module(ntdll+7a6b) (ZwGetContextThread+b)
0x005bcdd4 Module(sqlservr+1bcdd4) (ex_raise2+35c)
0x004f8616 Module(sqlservr+f8616) (ex_raise+5f)
0x0059cf32 Module(sqlservr+19cf32) (usedb+e5)
0x004318e7 Module(sqlservr+318e7) (CAutoDb::FUse+31)
0x00402c43 Module(sqlservr+2c43) (opentabid+77)
0x00432b43 Module(sqlservr+32b43) (CSysScan::OpenScan+b4)
0x00432899 Module(sqlservr+32899) (CSysScan::StartScan+93)
0x005f050f Module(sqlservr+1f050f) (CColumnScan::FFindById+3f)
0x006b4341 Module(sqlservr+2b4341) (CIdentity::VFlush+7f)
0x006b389b Module(sqlservr+2b389b) (CIdentity::VFlushForCheckpoint+190)
0x005a79a5 Module(sqlservr+1a79a5) (FlushIdentityValuesForCheckpoint+1b1)
0x00504371 Module(sqlservr+104371) (HardCheckpoint+12)
0x00503557 Module(sqlservr+103557) (DBMgr::CleanShutdownDB+b2)
0x005a6634 Module(sqlservr+1a6634) (DBMgr::TryToClose+20a)
0x00408a97 Module(sqlservr+8a97) (XDES::Close+1ab)
0x004095ff Module(sqlservr+95ff) (XDES::Commit+12d)
0x0040a145 Module(sqlservr+a145) (XCB::MinimizeLocks+a4)
0x004f98af Module(sqlservr+f98af) (clean_process+11b)
0x005bb0f4 Module(sqlservr+1bb0f4) (login+511)
0x41061225 Module(opends60+1225) (execute_event+659)
0x4106449b Module(opends60+449b) (process_login+95)
0x41061404 Module(opends60+1404) (process_commands+d6)
0x41092cff Module(ums+2cff) (ProcessWorkRequests+102)
0x41093523 Module(ums+3523) (ThreadStartRoutine+139)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ede Module(KERNEL32+4ede) (lstrcmpiW+be)