Cannot Start SQL Server 2000 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Cannot Start SQL Server 2000

Author

Topic

Cut_Creator
Starting Member

2 Posts

Posted - 2008-12-04 : 21:31:52

Hi!

There is a bug in SQL Server 2000 SP3 thats make the following error. This started after I put a second CPU in the server and change the SQL server to do parallel execution. MS have stated that is a bug in SP3 and is solved in SP4. The problem is that, that I can't run the SP4 setup because (as you now) the setup start's the SQL server to check logon info, integrity etc. I have tried every startup option available, even with other master.mdf's, read everything I could about the problem. But I cannot find a solution to my specific problem.

Any help appreciates.
Friendly Regards,
Sonny Wadstedt
SWEDEN

Below is the ERRORLOG (after that comes SQLDump0001.txt):
=========================================================================================
2008-12-05 03:12:35.50 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2008-12-05 03:12:36.11 server Copyright (C) 1988-2002 Microsoft Corporation.
2008-12-05 03:12:36.30 server All rights reserved.
2008-12-05 03:12:36.46 server Server Process ID is 2080.
2008-12-05 03:12:36.69 server Logging SQL Server messages in file 'D:\MSSQL\log\ERRORLOG'.
2008-12-05 03:12:37.00 server Warning: -f command line flag used...minimal server configured.
2008-12-05 03:12:37.28 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2008-12-05 03:12:40.24 server SQL Server configured for thread mode processing.
2008-12-05 03:12:40.52 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2008-12-05 03:12:40.91 server MS DTC initialization skipped because of start up option.
2008-12-05 03:12:41.11 spid4 Warning ******************
2008-12-05 03:12:41.22 spid4 SQL Server started in single user mode. Updates allowed to system catalogs.
2008-12-05 03:12:41.41 spid4 Starting up database 'master'.
2008-12-05 03:12:42.03 spid4 Server started with '-f'. Auditing will not be started.
2008-12-05 03:12:42.25 spid4 Server name is 'CHAOS'.
2008-12-05 03:12:42.27 spid5 Starting up database 'model'.
2008-12-05 03:12:42.27 server Using 'SSNETLIB.DLL' version '8.0.766'.
2008-12-05 03:12:43.03 spid5 Clearing tempdb database.
2008-12-05 03:12:48.11 spid5 Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to D:\MSSQL\log\SQLDump0001.txt
2008-12-05 03:12:48.75 spid5 SqlDumpExceptionHandler: Process 936 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/05/08 03:12:48 spid 5
*
2008-12-05 03:12:50.89 server SQL server listening on 192.168.0.100: 1433.
2008-12-05 03:12:51.07 server SQL server listening on 127.0.0.1: 1433.
2008-12-05 03:12:51.86 server SQL server listening on TCP, Shared Memory, Named Pipes.
2008-12-05 03:12:52.07 server SQL Server is ready for client connections
* Exception Address = 00469BC1 (InitExtBitmap + 00000002 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000000
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFBFFF 0007c000
* KERNEL32 7C570000 7C623FFF 000b4000
* ADVAPI32 7C2D0000 7C334FFF 00065000
* RPCRT4 77D30000 77D9EFFF 0006f000
* Secur32 7C340000 7C34EFFF 0000f000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 02850000 0289FFFF 00050000
* NTDSAPI 028A0000 028B0FFF 00011000
* DNSAPI 028C0000 028E3FFF 00024000
* WSOCK32 028F0000 028F7FFF 00008000
* WS2_32 02900000 02913FFF 00014000
* WS2HELP 02920000 02927FFF 00008000
* WLDAP32 02930000 0295AFFF 0002b000
* NETRAP 02960000 02965FFF 00006000
* SAMLIB 02970000 0297FFFF 00010000
* SSNETLIB 03060000 03074FFF 00015000
* SSNMPN70 03080000 03085FFF 00006000
* security 033C0000 033C3FFF 00004000
* crypt32 033E0000 0346BFFF 0008c000
* MSASN1 03490000 034A0FFF 00011000
* schannel 034C0000 034E6FFF 00027000
* USERENV 034F0000 03553FFF 00064000
* rsaenh 03570000 03592FFF 00023000
* ole32 03620000 0370EFFF 000ef000
* dssenh 03710000 03736FFF 00027000
* dbghelp 03740000 037F4FFF 000b5000
* VERSION 03800000 03806FFF 00007000
* LZ32 03810000 03815FFF 00006000
* shell32 03930000 03B75FFF 00246000
* SHLWAPI 03B80000 03BE5FFF 00066000
* COMCTL32 03BF0000 03C73FFF 00084000
*
* Edi: 42C64000: 00000B01 00000000 00000000 00000000 00000000 00010000
* Esi: 00001F98:
* Eax: 42C64064: 42C64064 00000000 00000000 00000000 00000000 00000000
* Ebx: 00000000:
* Ecx: 00001F9C:
* Edx: 42C64060: 1F9C0000 42C64064 00000000 00000000 00000000 00000000
* Eip: 00469BC1: 00000500 E5000000 00000477 20000000 00000000 3B000000
* Ebp: 0361F6E0: 0361F720 0052624D 0361F70C 00000008 0361F794 00000001
* SegCs: 0000001B:
* EFlags: 00010202: 004D0041 003D0045 00480043 004F0041 00000053 006F0043
* Esp: 0361F6A4: 00516370 42C64064 00001F98 00000000 03610001 00EB1E80
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 00469BC1 Module(sqlservr+00069BC1) (InitExtBitmap+00000002)
* 0052624D Module(sqlservr+0012624D) (InitPFSPages+0000020C)
* 00526086 Module(sqlservr+00126086) (InitDBAllocPages+00000055)
* 005160A5 Module(sqlservr+001160A5) (FileMgr::CreateNewFile+000000D1)
* 00515FAF Module(sqlservr+00115FAF) (BPool::GetClock+FFFF9364)
2008-12-05 03:14:21.66 server SQL Server shutdown due to Ctrl-C or Ctrl-Break signal.


HERE IS THE SQLDump0001.txt
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server 8.00.760
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is IBM BIOS Ver 7.0
Current time is 03:12:48 12/05/08.
2 Intel x86 level 6, 932 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.

Memory
MemoryLoad = 22%
Total Physical = 2047 MB
Available Physical = 1582 MB
Total Page File = 5164 MB
Available Page File = 4863 MB
Total Virtual = 2047 MB
Available Virtual = 356 MB

*Stack Dump being sent to D:\MSSQL\log\SQLDump0001.txt
* *****************************************************************************
**
*
* BEGIN STACK DUMP:
* 12/05/08 03:12:48 spid 5
*
* Exception Address = 00469BC1 (InitExtBitmap + 00000002 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000000
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFBFFF 0007c000
* KERNEL32 7C570000 7C623FFF 000b4000
* ADVAPI32 7C2D0000 7C334FFF 00065000
* RPCRT4 77D30000 77D9EFFF 0006f000
* Secur32 7C340000 7C34EFFF 0000f000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F7BFFF 0003c000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 02850000 0289FFFF 00050000
* NTDSAPI 028A0000 028B0FFF 00011000
* DNSAPI 028C0000 028E3FFF 00024000
* WSOCK32 028F0000 028F7FFF 00008000
* WS2_32 02900000 02913FFF 00014000
* WS2HELP 02920000 02927FFF 00008000
* WLDAP32 02930000 0295AFFF 0002b000
* NETRAP 02960000 02965FFF 00006000
* SAMLIB 02970000 0297FFFF 00010000
* SSNETLIB 03060000 03074FFF 00015000
* SSNMPN70 03080000 03085FFF 00006000
* security 033C0000 033C3FFF 00004000
* crypt32 033E0000 0346BFFF 0008c000
* MSASN1 03490000 034A0FFF 00011000
* schannel 034C0000 034E6FFF 00027000
* USERENV 034F0000 03553FFF 00064000
* rsaenh 03570000 03592FFF 00023000
* ole32 03620000 0370EFFF 000ef000
* dssenh 03710000 03736FFF 00027000
* dbghelp 03740000 037F4FFF 000b5000
* VERSION 03800000 03806FFF 00007000
* LZ32 03810000 03815FFF 00006000
* shell32 03930000 03B75FFF 00246000
* SHLWAPI 03B80000 03BE5FFF 00066000
* COMCTL32 03BF0000 03C73FFF 00084000
*
* Edi: 42C64000: 00000B01 00000000 00000000 00000000 00000000 00010
000
* Esi: 00001F98:
* Eax: 42C64064: 42C64064 00000000 00000000 00000000 00000000 00000
000
* Ebx: 00000000:
* Ecx: 00001F9C:
* Edx: 42C64060: 1F9C0000 42C64064 00000000 00000000 00000000 00000
000
* Eip: 00469BC1: 00000500 E5000000 00000477 20000000 00000000 3B000
000
* Ebp: 0361F6E0: 0361F720 0052624D 0361F70C 00000008 0361F794 00000
001
* SegCs: 0000001B:
* EFlags: 00010202: 004D0041 003D0045 00480043 004F0041 00000053 006F0
043
* Esp: 0361F6A4: 00516370 42C64064 00001F98 00000000 03610001 00EB1
E80
* SegSs: 00000023:
* *****************************************************************************
**
* -----------------------------------------------------------------------------
--
* Short Stack Dump
* 00469BC1 Module(sqlservr+00069BC1) (InitExtBitmap+00000002)
* 0052624D Module(sqlservr+0012624D) (InitPFSPages+0000020C)
* 00526086 Module(sqlservr+00126086) (InitDBAllocPages+00000055)
* 005160A5 Module(sqlservr+001160A5) (FileMgr::CreateNewFile+000000D1)
* 00515FAF Module(sqlservr+00115FAF) (BPool::GetClock+FFFF9364)

SimpleSQL
Yak Posting Veteran

85 Posts

Posted - 2008-12-05 : 00:51:30

You said this is a known issue with SQL 2000, what is KB number? Hard to say what is the issue just looking at the above message abviously SQL is generating exception, only support can tell reason looking at the dump.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-12-05 : 01:37:50

You didn't explain clearly why you can't run SP4.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Cut_Creator
Starting Member

2 Posts

Posted - 2008-12-06 : 17:53:55

Well, I just think I did that. I'll get exact the same error's (as abow) in the log when I try to run SP4.
As I said, the SQL Server wont start correct because of a fatal exception error following with a stack dump.
If anybody know how I can install SP4 without that the setup have to start SQL Server, tell me - and the problems solved...
//Sonny

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-12-07 : 03:43:17

Can you remove or disable the second processor?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources