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)




Relevant Pages

  • Re: SQL server connection problem
    ... Transaction Log containt all your activities about the database that it belongs to. ... Makes a backup copy of a database (DUMP DATABASE) or makes a copy of the transaction log in a form that can be read into Microsoft® SQL Server™ using the BACKUP or LOAD statements. ... Important The DUMP statement is included in SQL Server version 2000 for backward compatibility. ... I've tried to change the user connections to> 0, ...
    (microsoft.public.sqlserver.clients)
  • Re: import mysql dump file in sql server
    ... > does anyone have a good idea how i can easily import a mysql dump ... > file in a sql server 2000 enterprise edition ... > The dump file is 7 gig big however my MS SQL server is a DELL ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrate data to MS SQL from D3NT
    ... I got a project to move data from D3NT server to MS SQL server. ... are the tools within D3NT to dump the data so we can move it to SQL? ... Are you planning to convert derived data (other than t-file foreign ...
    (comp.databases.pick)
  • Re: 1:1 Kopie von einem SQL-Server erstellen (Test-Server einrichten)
    ... Servicepack ... SQL Server 7.0 inkl. ... alle Benutzer-Datenbanken mittles RESTORE vom Dump geladen ...
    (microsoft.public.de.sqlserver)
  • Re: Access Violation after upgrade to SQL 2000 sp3a
    ... I suggest you contact MS PSS so they can work directly with you to ... SQL Server MVP ... > Everything working OK with hundreds of users attached> except for intermittent Access Violation - see dump below. ... > * BEGIN STACK DUMP: ...
    (microsoft.public.sqlserver.programming)