Can not start SQL server and server agent

Can not start SQL server and server agent

Post by Jasper Smit » Thu, 30 Jan 2003 19:22:24



What are the file versions of sqlservr.exe and ssnetlib.dll ?

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Julie Shi" <Julie...@Lucent.com> wrote in message

news:#YXE076xCHA.1928@TK2MSFTNGP10...
Hi,

I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I installed
the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

Then I found the MQSQLSERVER and SQL server agent services can not be
started.

At the beginning, the SQL server service was started, but the server agent
could not be started. The errorlog file is attached: errorlog - no server
agent.txt.

Then my PC was restarted by itself. After that both SQL server and SQL
server agent could not be started. errorlog file attached: errorlog - no
server.txt.

Could someone tell me why?

Julie

==================================================

errorlog - no server.txt:

2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194 (Intel
X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft Corporation.

2003-01-29 09:15:52.88 server All rights reserved.

2003-01-29 09:15:52.88 server Server Process ID is 752.

2003-01-29 09:15:52.88 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2003-01-29 09:15:53.28 server SQL Server is starting at priority class
'normal'(1 CPU detected).

2003-01-29 09:15:53.39 server SQL Server configured for thread mode
processing.

2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.

2003-01-29 09:15:53.42 server Attempting to initialize Distributed
Transaction Coordinator.

2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

2003-01-29 09:15:55.62 server Operating system error 0: The operation
completed successfully...

2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server shutting
down.

=====================================================================

errorlog - no server agent.txt:

2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194 (Intel
X86)

Aug 6 2000 00:57:48

Copyright (c) 1988-2000 Microsoft Corporation

Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft Corporation.

2003-01-29 09:00:40.65 server All rights reserved.

2003-01-29 09:00:40.65 server Server Process ID is 796.

2003-01-29 09:00:40.65 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

2003-01-29 09:00:41.78 server SQL Server is starting at priority class
'normal'(1 CPU detected).

2003-01-29 09:00:46.36 server SQL Server configured for thread mode
processing.

2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.

2003-01-29 09:00:49.30 server Attempting to initialize Distributed
Transaction Coordinator.

2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40: 1433.

2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared Memory,
Named Pipes.

2003-01-29 09:01:09.43 server SQL Server is ready for client connections

2003-01-29 09:01:11.14 spid3 Recovery complete.

2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQL00010.dmp

2003-01-29 09:01:48.97 server process_loginread: Process 1340 generated
fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.

****************************************************************************
***

*

* BEGIN STACK DUMP:

* 01/29/03 09:01:48 spid 0

*

* Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
3414+00000003)

* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

* Access Violation occurred writing address 4107160C

*

* MODULE BASE END SIZE

* sqlservr 00400000 00B19FFF 0071a000

* ntdll 77F80000 77FFAFFF 0007b000

* KERNEL32 77E80000 77F30FFF 000b1000

* ADVAPI32 77DB0000 77E0AFFF 0005b000

* RPCRT4 77D30000 77DA0FFF 00071000

* USER32 77E10000 77E6EFFF 0005f000

* GDI32 77F40000 77F78FFF 00039000

* OPENDS60 41060000 41065FFF 00006000

* MSVCRT 78000000 78045FFF 00046000

* UMS 41070000 4107CFFF 0000d000

* SQLSORT 42AE0000 42B6FFFF 00090000

* MSVCIRT 780A0000 780B1FFF 00012000

* sqlevn70 41080000 41086FFF 00007000

* NETAPI32 75170000 751BEFFF 0004f000

* Secur32 77BE0000 77BEEFFF 0000f000

* NETRAP 751C0000 751C5FFF 00006000

* SAMLIB 75150000 7515FFFF 00010000

* WS2_32 75030000 75042FFF 00013000

* WS2HELP 75020000 75027FFF 00008000

* WLDAP32 77950000 77977FFF 00028000

* DNSAPI 77980000 779A3FFF 00024000

* WSOCK32 75050000 75057FFF 00008000

* wmi 76110000 76113FFF 00004000

* ole32 77A50000 77B44FFF 000f5000

* XOLEHLP 65450000 65457FFF 00008000

* MSDTCPRX 6DF80000 6E032FFF 000b3000

* MTXCLU 6A7A0000 6A7AFFFF 00010000

* VERSION 77820000 77826FFF 00007000

* LZ32 759B0000 759B5FFF 00006000

* CLUSAPI 73930000 7393FFFF 00010000

* RESUTILS 689D0000 689DCFFF 0000d000

* USERENV 77C10000 77C6CFFF 0005d000

* rnr20 782C0000 782CBFFF 0000c000

* iphlpapi 77340000 77352FFF 00013000

* ICMP 77520000 77524FFF 00005000

* MPRAPI 77320000 77336FFF 00017000

* OLEAUT32 779B0000 77A4AFFF 0009b000

* ACTIVEDS 773B0000 773DDFFF 0002e000

* ADSLDPC 77380000 773A1FFF 00022000

* RTUTILS 77830000 7783DFFF 0000e000

* SETUPAPI 77880000 7790CFFF 0008d000

* RASAPI32 774E0000 77511FFF 00032000

* RASMAN 774C0000 774D0FFF 00011000

* TAPI32 77530000 77551FFF 00022000

* COMCTL32 716F0000 71779FFF 0008a000

* SHLWAPI 70BD0000 70C1BFFF 0004c000

* DHCPCSVC 77360000 77378FFF 00019000

* winrnr 777E0000 777E7FFF 00008000

* rasadhlp 777F0000 777F4FFF 00005000

* SSNETLIB 42CF0000 42D04FFF 00015000

* SSNMPN70 410D0000 410D5FFF 00006000

* security 75500000 75503FFF 00004000

* msafd 74FD0000 74FECFFF 0001d000

* wshtcpip 75010000 75016FFF 00007000

* SSmsLPCn 42CD0000 42CD6FFF 00007000

* ntdsapi 77BF0000 77C00FFF 00011000

* sqlimage 4A400000 4A40CFFF 0000d000

* DBGHELP 2ACF0000 2AD02FFF 00013000

*

* Edi: 194FE3F8: 00000000 194FFFF0 00000001 10000008 194FE018 194FFFF0

* Esi: 194FE090: 194FE3F8 00000000 00000002 00030308 194FE030 00000000

* Eax: 29974270: FFFF0002 00000000 00000000 00000000 00000000 00000000

* Ebx: 00000000:

* Ecx: 4107160C: A1EC8B55 41079000 2C0D8B64 8B000000 428B8114 55C35D04

* Edx: 0000053C:

* Eip: 42CF3DD4: 000001C7 558B0000 90BA83FC 00000000 458B0E74 0B00C718

* Ebp: 2AB5FE58: 2AB5FE88 00417861 29974270 194FE408 00000008 00001000

* SegCs: 0000001B:

* EFlags: 00010206: 00490057 004E004E 005C0054 00790073 00740073 006D0065

* Esp: 2AB5FE18: 00000000 2AB5FE2C 0040204E 1939EC00 1939C030 2AB5FE3C

* SegSs: 00000023:

****************************************************************************
***

----------------------------------------------------------------------------
---

Short Stack Dump

42CF3DD4 Module(SSNETLIB+00003DD4) (_ConnectionReadAsync+0000001D Line
3414+00000003)

00417861 Module(sqlservr+00017861) (net_requestread(struct srv_proc
*,int)+000000CC)

00534828 Module(sqlservr+00134828) (process_loginread(struct srv_proc
*)+00000089)

410735D0 Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)

4107382C Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)

7800C9EB Module(MSVCRT+0000C9EB) (_beginthread+000000CE)

77E8B2D8 Module(KERNEL32+0000B2D8) (lstrcmpiW+000000B7)

----------------------------------------------------------------------------
---

Dump thread - spid = 1, PSS = 0x19406090, EC = 0x194063a0

Stack Dump being sent to C:\Program Files\Microsoft SQL
Server\MSSQL\log\SQL00010.dmp

****************************************************************************
***

*

* BEGIN STACK DUMP:

* 01/29/03 09:02:07 spid 1

*

* StackDump (all)

*

*

*

* Edi: 00000200:

* Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454

* Eax: 00002BB0:

* Ebx: 00000000:

* Ecx: 00000000:

* Edx: 00000000:

* Eip: 77F83786: B8000CC2 0000001C 0424548D FAE92ECD B8000169 000000D4

* Ebp: 29D1FB80: 29D1FB9C 4107149D 00000200 FFFFFFFF 00000001 00E465D8

* SegCs: 0000001B:

* EFlags: 00000246:

* Esp: 29D1FB5C: 77EA9B35 00000200 00000001 00000000 19406568 41071883

* SegSs: 00000023:

****************************************************************************
***

----------------------------------------------------------------------------
---

Short Stack Dump

77F83786 Module(ntdll+00003786) (ZwWaitForSingleObject+0000000B)

4107149D Module(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class UmsUserContext *)+00000058)

4107173F Module(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)

410717FF Module(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)

41071918 Module(UMS+00001918) (UmsEvent::Wait(unsigned
long,int,int)+00000095)

0040129C Module(sqlservr+0000129C) (ExecutionContext::WaitForSignal(unsigned
long,unsigned ...

read more »

 
 
 

Can not start SQL server and server agent

Post by Ramesh Singh[MSFT » Thu, 30 Jan 2003 21:00:07


I noticed that the log is reflecting that your are still on SQL 2000 RTM
release (build 194); SP2 is build 534

--
Ramesh Singh

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Jasper Smith" <jasper_smi...@hotmail.com> wrote in message

news:uDLxSs7xCHA.1900@TK2MSFTNGP10...
> What are the file versions of sqlservr.exe and ssnetlib.dll ?

> --
> HTH

> Jasper Smith (SQL Server MVP)

> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org

> "Julie Shi" <Julie...@Lucent.com> wrote in message
> news:#YXE076xCHA.1928@TK2MSFTNGP10...
> Hi,

> I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I
installed
> the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

> Then I found the MQSQLSERVER and SQL server agent services can not be
> started.

> At the beginning, the SQL server service was started, but the server agent
> could not be started. The errorlog file is attached: errorlog - no server
> agent.txt.

> Then my PC was restarted by itself. After that both SQL server and SQL
> server agent could not be started. errorlog file attached: errorlog - no
> server.txt.

> Could someone tell me why?

> Julie

> ==================================================

> errorlog - no server.txt:

> 2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194 (Intel
> X86)

> Aug 6 2000 00:57:48

> Copyright (c) 1988-2000 Microsoft Corporation

> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> 2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft
Corporation.

> 2003-01-29 09:15:52.88 server All rights reserved.

> 2003-01-29 09:15:52.88 server Server Process ID is 752.

> 2003-01-29 09:15:52.88 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> 2003-01-29 09:15:53.28 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).

> 2003-01-29 09:15:53.39 server SQL Server configured for thread mode
> processing.

> 2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.

> 2003-01-29 09:15:53.42 server Attempting to initialize Distributed
> Transaction Coordinator.

> 2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

> 2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

> 2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

> 2003-01-29 09:15:55.62 server Operating system error 0: The operation
> completed successfully...

> 2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server shutting
> down.

> =====================================================================

> errorlog - no server agent.txt:

> 2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194 (Intel
> X86)

> Aug 6 2000 00:57:48

> Copyright (c) 1988-2000 Microsoft Corporation

> Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> 2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft
Corporation.

> 2003-01-29 09:00:40.65 server All rights reserved.

> 2003-01-29 09:00:40.65 server Server Process ID is 796.

> 2003-01-29 09:00:40.65 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> 2003-01-29 09:00:41.78 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).

> 2003-01-29 09:00:46.36 server SQL Server configured for thread mode
> processing.

> 2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.

> 2003-01-29 09:00:49.30 server Attempting to initialize Distributed
> Transaction Coordinator.

> 2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

> 2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

> 2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

> 2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

> 2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40:
1433.

> 2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

> 2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

> 2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

> 2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

> 2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

> 2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

> 2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

> 2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared Memory,
> Named Pipes.

> 2003-01-29 09:01:09.43 server SQL Server is ready for client connections

> 2003-01-29 09:01:11.14 spid3 Recovery complete.

> 2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

> Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQL00010.dmp

> 2003-01-29 09:01:48.97 server process_loginread: Process 1340 generated
> fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
> terminating this process.

****************************************************************************

- Show quoted text -

> ***

> *

> * BEGIN STACK DUMP:

> * 01/29/03 09:01:48 spid 0

> *

> * Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
> 3414+00000003)

> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

> * Access Violation occurred writing address 4107160C

> *

> * MODULE BASE END SIZE

> * sqlservr 00400000 00B19FFF 0071a000

> * ntdll 77F80000 77FFAFFF 0007b000

> * KERNEL32 77E80000 77F30FFF 000b1000

> * ADVAPI32 77DB0000 77E0AFFF 0005b000

> * RPCRT4 77D30000 77DA0FFF 00071000

> * USER32 77E10000 77E6EFFF 0005f000

> * GDI32 77F40000 77F78FFF 00039000

> * OPENDS60 41060000 41065FFF 00006000

> * MSVCRT 78000000 78045FFF 00046000

> * UMS 41070000 4107CFFF 0000d000

> * SQLSORT 42AE0000 42B6FFFF 00090000

> * MSVCIRT 780A0000 780B1FFF 00012000

> * sqlevn70 41080000 41086FFF 00007000

> * NETAPI32 75170000 751BEFFF 0004f000

> * Secur32 77BE0000 77BEEFFF 0000f000

> * NETRAP 751C0000 751C5FFF 00006000

> * SAMLIB 75150000 7515FFFF 00010000

> * WS2_32 75030000 75042FFF 00013000

> * WS2HELP 75020000 75027FFF 00008000

> * WLDAP32 77950000 77977FFF 00028000

> * DNSAPI 77980000 779A3FFF 00024000

> * WSOCK32 75050000 75057FFF 00008000

> * wmi 76110000 76113FFF 00004000

> * ole32 77A50000 77B44FFF 000f5000

> * XOLEHLP 65450000 65457FFF 00008000

> * MSDTCPRX 6DF80000 6E032FFF 000b3000

> * MTXCLU 6A7A0000 6A7AFFFF 00010000

> * VERSION 77820000 77826FFF 00007000

> * LZ32 759B0000 759B5FFF 00006000

> * CLUSAPI 73930000 7393FFFF 00010000

> * RESUTILS 689D0000 689DCFFF 0000d000

> * USERENV 77C10000 77C6CFFF 0005d000

> * rnr20 782C0000 782CBFFF 0000c000

> * iphlpapi 77340000 77352FFF 00013000

> * ICMP 77520000 77524FFF 00005000

> * MPRAPI 77320000 77336FFF 00017000

> * OLEAUT32 779B0000 77A4AFFF 0009b000

> * ACTIVEDS 773B0000 773DDFFF 0002e000

> * ADSLDPC 77380000 773A1FFF 00022000

> * RTUTILS 77830000 7783DFFF 0000e000

> * SETUPAPI 77880000 7790CFFF 0008d000

> * RASAPI32 774E0000 77511FFF 00032000

> * RASMAN 774C0000 774D0FFF 00011000

> * TAPI32 77530000 77551FFF 00022000

> * COMCTL32 716F0000 71779FFF 0008a000

> * SHLWAPI 70BD0000 70C1BFFF 0004c000

> * DHCPCSVC 77360000 77378FFF 00019000

> * winrnr 777E0000 777E7FFF 00008000

> * rasadhlp 777F0000 777F4FFF 00005000

> * SSNETLIB 42CF0000 42D04FFF 00015000

> * SSNMPN70 410D0000 410D5FFF 00006000

> * security 75500000 75503FFF 00004000

> * msafd 74FD0000 74FECFFF 0001d000

> * wshtcpip 75010000 75016FFF 00007000

> * SSmsLPCn 42CD0000 42CD6FFF 00007000

> * ntdsapi 77BF0000 77C00FFF 00011000

> * sqlimage 4A400000 4A40CFFF 0000d000

> * DBGHELP 2ACF0000 2AD02FFF 00013000

> *

> * Edi: 194FE3F8: 00000000 194FFFF0 00000001 10000008 194FE018 194FFFF0

> * Esi: 194FE090: 194FE3F8 00000000 00000002 00030308 194FE030 00000000

> * Eax: 29974270: FFFF0002 00000000 00000000 00000000 00000000 00000000

> * Ebx: 00000000:

> * Ecx: 4107160C: A1EC8B55 41079000 2C0D8B64 8B000000 428B8114 55C35D04

> * Edx: 0000053C:

> * Eip: 42CF3DD4: 000001C7 558B0000 90BA83FC 00000000 458B0E74 0B00C718

> * Ebp: 2AB5FE58: 2AB5FE88 00417861 29974270 194FE408 00000008 00001000

> * SegCs: 0000001B:

> * EFlags: 00010206: 00490057 004E004E 005C0054 00790073 00740073 006D0065

> * Esp: 2AB5FE18: 00000000 2AB5FE2C 0040204E 1939EC00 1939C030 2AB5FE3C

> * SegSs: 00000023:

****************************************************************************

- Show quoted text -

> ***

> --------------------------------------------------------------------------
--
> ---

> Short Stack Dump

> 42CF3DD4 Module(SSNETLIB+00003DD4) (_ConnectionReadAsync+0000001D Line
> 3414+00000003)

> 00417861 Module(sqlservr+00017861) (net_requestread(struct srv_proc
> *,int)+000000CC)

> 00534828 Module(sqlservr+00134828) (process_loginread(struct srv_proc
> *)+00000089)

> 410735D0 Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
> *)+00000264)

> 4107382C Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)

> 7800C9EB Module(MSVCRT+0000C9EB) (_beginthread+000000CE)

> 77E8B2D8 Module(KERNEL32+0000B2D8) (lstrcmpiW+000000B7)

> --------------------------------------------------------------------------
--
> ---

> Dump thread - spid = 1, PSS = 0x19406090, EC = 0x194063a0

> Stack Dump being sent to C:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQL00010.dmp

****************************************************************************

- Show quoted text -

> ***

> *

> * BEGIN STACK DUMP:

> * 01/29/03 09:02:07 spid 1

> *

> * StackDump (all)

> *

> *

> *

> * Edi: 00000200:

> * Esi: 77F8377B: 0000EAB8 24548D00 C22ECD04 1CB8000C 8D000000 CD042454

> * Eax: 00002BB0:

> * Ebx: 00000000:

...

read more »

 
 
 

Can not start SQL server and server agent

Post by Julie Sh » Thu, 30 Jan 2003 21:51:18


The file version for sqlservr.exe is 8.00.194. (in C:\Program
Files\Microsoft SQL Server\MSSQL\Binn)

The file version for ssnetlib.dll in the install path (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn) is 8.00.636 after apply the hot fix.

The ssnetlib.phd in the install path (C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\exe) is dated 6/3/2002.

"Ramesh Singh[MSFT]" <rame...@microsoft.com> wrote in message

news:uxcpXi8xCHA.2512@TK2MSFTNGP11...
> I noticed that the log is reflecting that your are still on SQL 2000 RTM
> release (build 194); SP2 is build 534

> --
> Ramesh Singh

> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
> "Jasper Smith" <jasper_smi...@hotmail.com> wrote in message
> news:uDLxSs7xCHA.1900@TK2MSFTNGP10...
> > What are the file versions of sqlservr.exe and ssnetlib.dll ?

> > --
> > HTH

> > Jasper Smith (SQL Server MVP)

> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org

> > "Julie Shi" <Julie...@Lucent.com> wrote in message
> > news:#YXE076xCHA.1928@TK2MSFTNGP10...
> > Hi,

> > I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I
> installed
> > the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

> > Then I found the MQSQLSERVER and SQL server agent services can not be
> > started.

> > At the beginning, the SQL server service was started, but the server
agent
> > could not be started. The errorlog file is attached: errorlog - no
server
> > agent.txt.

> > Then my PC was restarted by itself. After that both SQL server and SQL
> > server agent could not be started. errorlog file attached: errorlog - no
> > server.txt.

> > Could someone tell me why?

> > Julie

> > ==================================================

> > errorlog - no server.txt:

> > 2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194
(Intel
> > X86)

> > Aug 6 2000 00:57:48

> > Copyright (c) 1988-2000 Microsoft Corporation

> > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > 2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft
> Corporation.

> > 2003-01-29 09:15:52.88 server All rights reserved.

> > 2003-01-29 09:15:52.88 server Server Process ID is 752.

> > 2003-01-29 09:15:52.88 server Logging SQL Server messages in file
> > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > 2003-01-29 09:15:53.28 server SQL Server is starting at priority class
> > 'normal'(1 CPU detected).

> > 2003-01-29 09:15:53.39 server SQL Server configured for thread mode
> > processing.

> > 2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500] Lock
> > Blocks, [5000] Lock Owner Blocks.

> > 2003-01-29 09:15:53.42 server Attempting to initialize Distributed
> > Transaction Coordinator.

> > 2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

> > 2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

> > 2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

> > 2003-01-29 09:15:55.62 server Operating system error 0: The operation
> > completed successfully...

> > 2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server
shutting
> > down.

> > =====================================================================

> > errorlog - no server agent.txt:

> > 2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194
(Intel
> > X86)

> > Aug 6 2000 00:57:48

> > Copyright (c) 1988-2000 Microsoft Corporation

> > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > 2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft
> Corporation.

> > 2003-01-29 09:00:40.65 server All rights reserved.

> > 2003-01-29 09:00:40.65 server Server Process ID is 796.

> > 2003-01-29 09:00:40.65 server Logging SQL Server messages in file
> > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > 2003-01-29 09:00:41.78 server SQL Server is starting at priority class
> > 'normal'(1 CPU detected).

> > 2003-01-29 09:00:46.36 server SQL Server configured for thread mode
> > processing.

> > 2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500] Lock
> > Blocks, [5000] Lock Owner Blocks.

> > 2003-01-29 09:00:49.30 server Attempting to initialize Distributed
> > Transaction Coordinator.

> > 2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

> > 2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

> > 2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

> > 2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

> > 2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40:
> 1433.

> > 2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

> > 2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

> > 2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

> > 2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

> > 2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

> > 2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

> > 2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

> > 2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared
Memory,
> > Named Pipes.

> > 2003-01-29 09:01:09.43 server SQL Server is ready for client connections

> > 2003-01-29 09:01:11.14 spid3 Recovery complete.

> > 2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

> > Stack Dump being sent to C:\Program Files\Microsoft SQL
> > Server\MSSQL\log\SQL00010.dmp

> > 2003-01-29 09:01:48.97 server process_loginread: Process 1340 generated
> > fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > terminating this process.

****************************************************************************

- Show quoted text -

> > ***

> > *

> > * BEGIN STACK DUMP:

> > * 01/29/03 09:01:48 spid 0

> > *

> > * Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
> > 3414+00000003)

> > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

> > * Access Violation occurred writing address 4107160C

> > *

> > * MODULE BASE END SIZE

> > * sqlservr 00400000 00B19FFF 0071a000

> > * ntdll 77F80000 77FFAFFF 0007b000

> > * KERNEL32 77E80000 77F30FFF 000b1000

> > * ADVAPI32 77DB0000 77E0AFFF 0005b000

> > * RPCRT4 77D30000 77DA0FFF 00071000

> > * USER32 77E10000 77E6EFFF 0005f000

> > * GDI32 77F40000 77F78FFF 00039000

> > * OPENDS60 41060000 41065FFF 00006000

> > * MSVCRT 78000000 78045FFF 00046000

> > * UMS 41070000 4107CFFF 0000d000

> > * SQLSORT 42AE0000 42B6FFFF 00090000

> > * MSVCIRT 780A0000 780B1FFF 00012000

> > * sqlevn70 41080000 41086FFF 00007000

> > * NETAPI32 75170000 751BEFFF 0004f000

> > * Secur32 77BE0000 77BEEFFF 0000f000

> > * NETRAP 751C0000 751C5FFF 00006000

> > * SAMLIB 75150000 7515FFFF 00010000

> > * WS2_32 75030000 75042FFF 00013000

> > * WS2HELP 75020000 75027FFF 00008000

> > * WLDAP32 77950000 77977FFF 00028000

> > * DNSAPI 77980000 779A3FFF 00024000

> > * WSOCK32 75050000 75057FFF 00008000

> > * wmi 76110000 76113FFF 00004000

> > * ole32 77A50000 77B44FFF 000f5000

> > * XOLEHLP 65450000 65457FFF 00008000

> > * MSDTCPRX 6DF80000 6E032FFF 000b3000

> > * MTXCLU 6A7A0000 6A7AFFFF 00010000

> > * VERSION 77820000 77826FFF 00007000

> > * LZ32 759B0000 759B5FFF 00006000

> > * CLUSAPI 73930000 7393FFFF 00010000

> > * RESUTILS 689D0000 689DCFFF 0000d000

> > * USERENV 77C10000 77C6CFFF 0005d000

> > * rnr20 782C0000 782CBFFF 0000c000

> > * iphlpapi 77340000 77352FFF 00013000

> > * ICMP 77520000 77524FFF 00005000

> > * MPRAPI 77320000 77336FFF 00017000

> > * OLEAUT32 779B0000 77A4AFFF 0009b000

> > * ACTIVEDS 773B0000 773DDFFF 0002e000

> > * ADSLDPC 77380000 773A1FFF 00022000

> > * RTUTILS 77830000 7783DFFF 0000e000

> > * SETUPAPI 77880000 7790CFFF 0008d000

> > * RASAPI32 774E0000 77511FFF 00032000

> > * RASMAN 774C0000 774D0FFF 00011000

> > * TAPI32 77530000 77551FFF 00022000

> > * COMCTL32 716F0000 71779FFF 0008a000

> > * SHLWAPI 70BD0000 70C1BFFF 0004c000

> > * DHCPCSVC 77360000 77378FFF 00019000

> > * winrnr 777E0000 777E7FFF 00008000

> > * rasadhlp 777F0000 777F4FFF 00005000

> > * SSNETLIB 42CF0000 42D04FFF 00015000

> > * SSNMPN70 410D0000 410D5FFF 00006000

> > * security 75500000 75503FFF 00004000

> > * msafd 74FD0000 74FECFFF 0001d000

> > * wshtcpip 75010000 75016FFF 00007000

> > * SSmsLPCn 42CD0000 42CD6FFF 00007000

> > * ntdsapi 77BF0000 77C00FFF 00011000

> > * sqlimage 4A400000 4A40CFFF 0000d000

> > * DBGHELP 2ACF0000 2AD02FFF 00013000

> > *

> > * Edi: 194FE3F8: 00000000 194FFFF0 00000001 10000008 194FE018 194FFFF0

> > * Esi: 194FE090: 194FE3F8 00000000 00000002 00030308 194FE030 00000000

> > * Eax: 29974270: FFFF0002 00000000 00000000 00000000 00000000 00000000

> > * Ebx: 00000000:

> > * Ecx: 4107160C: A1EC8B55 41079000 2C0D8B64 8B000000 428B8114 55C35D04

> > * Edx: 0000053C:

> > * Eip: 42CF3DD4: 000001C7 558B0000 90BA83FC 00000000 458B0E74 0B00C718

> > * Ebp: 2AB5FE58: 2AB5FE88 00417861 29974270 194FE408 00000008 00001000

> > * SegCs: 0000001B:

> > * EFlags: 00010206: 00490057 004E004E 005C0054 00790073 00740073
006D0065

> > * Esp: 2AB5FE18: 00000000 2AB5FE2C 0040204E 1939EC00 1939C030 2AB5FE3C

> > * SegSs: 00000023:

****************************************************************************

- Show quoted text -

> > ***

> --------------------------------------------------------------------------
> --
> > ---

> > Short

...

read more »

 
 
 

Can not start SQL server and server agent

Post by SQL Server Development Team [MSFT » Thu, 30 Jan 2003 23:19:42


It looks like the SP2 upgrade was not successful.  Try running SP2 again.

Thanks,
Dan Winn
Program Manager, SQL Server Engine, Microsoft Corp.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Julie Shi" <Julie...@Lucent.com> wrote in message

news:eVC7$#8xCHA.2916@TK2MSFTNGP09...
> The file version for sqlservr.exe is 8.00.194. (in C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn)

> The file version for ssnetlib.dll in the install path (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn) is 8.00.636 after apply the hot
fix.

> The ssnetlib.phd in the install path (C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\exe) is dated 6/3/2002.

> "Ramesh Singh[MSFT]" <rame...@microsoft.com> wrote in message
> news:uxcpXi8xCHA.2512@TK2MSFTNGP11...
> > I noticed that the log is reflecting that your are still on SQL 2000 RTM
> > release (build 194); SP2 is build 534

> > --
> > Ramesh Singh

> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm.
> > "Jasper Smith" <jasper_smi...@hotmail.com> wrote in message
> > news:uDLxSs7xCHA.1900@TK2MSFTNGP10...
> > > What are the file versions of sqlservr.exe and ssnetlib.dll ?

> > > --
> > > HTH

> > > Jasper Smith (SQL Server MVP)

> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org

> > > "Julie Shi" <Julie...@Lucent.com> wrote in message
> > > news:#YXE076xCHA.1928@TK2MSFTNGP10...
> > > Hi,

> > > I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I
> > installed
> > > the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

> > > Then I found the MQSQLSERVER and SQL server agent services can not be
> > > started.

> > > At the beginning, the SQL server service was started, but the server
> agent
> > > could not be started. The errorlog file is attached: errorlog - no
> server
> > > agent.txt.

> > > Then my PC was restarted by itself. After that both SQL server and SQL
> > > server agent could not be started. errorlog file attached: errorlog -
no
> > > server.txt.

> > > Could someone tell me why?

> > > Julie

> > > ==================================================

> > > errorlog - no server.txt:

> > > 2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194
> (Intel
> > > X86)

> > > Aug 6 2000 00:57:48

> > > Copyright (c) 1988-2000 Microsoft Corporation

> > > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > > 2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft
> > Corporation.

> > > 2003-01-29 09:15:52.88 server All rights reserved.

> > > 2003-01-29 09:15:52.88 server Server Process ID is 752.

> > > 2003-01-29 09:15:52.88 server Logging SQL Server messages in file
> > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > > 2003-01-29 09:15:53.28 server SQL Server is starting at priority class
> > > 'normal'(1 CPU detected).

> > > 2003-01-29 09:15:53.39 server SQL Server configured for thread mode
> > > processing.

> > > 2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500]
Lock
> > > Blocks, [5000] Lock Owner Blocks.

> > > 2003-01-29 09:15:53.42 server Attempting to initialize Distributed
> > > Transaction Coordinator.

> > > 2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

> > > 2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

> > > 2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

> > > 2003-01-29 09:15:55.62 server Operating system error 0: The operation
> > > completed successfully...

> > > 2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server
> shutting
> > > down.

> > > =====================================================================

> > > errorlog - no server agent.txt:

> > > 2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194
> (Intel
> > > X86)

> > > Aug 6 2000 00:57:48

> > > Copyright (c) 1988-2000 Microsoft Corporation

> > > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > > 2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft
> > Corporation.

> > > 2003-01-29 09:00:40.65 server All rights reserved.

> > > 2003-01-29 09:00:40.65 server Server Process ID is 796.

> > > 2003-01-29 09:00:40.65 server Logging SQL Server messages in file
> > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > > 2003-01-29 09:00:41.78 server SQL Server is starting at priority class
> > > 'normal'(1 CPU detected).

> > > 2003-01-29 09:00:46.36 server SQL Server configured for thread mode
> > > processing.

> > > 2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500]
Lock
> > > Blocks, [5000] Lock Owner Blocks.

> > > 2003-01-29 09:00:49.30 server Attempting to initialize Distributed
> > > Transaction Coordinator.

> > > 2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

> > > 2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

> > > 2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

> > > 2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

> > > 2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40:
> > 1433.

> > > 2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

> > > 2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

> > > 2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

> > > 2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

> > > 2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

> > > 2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

> > > 2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

> > > 2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared
> Memory,
> > > Named Pipes.

> > > 2003-01-29 09:01:09.43 server SQL Server is ready for client
connections

> > > 2003-01-29 09:01:11.14 spid3 Recovery complete.

> > > 2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

> > > Stack Dump being sent to C:\Program Files\Microsoft SQL
> > > Server\MSSQL\log\SQL00010.dmp

> > > 2003-01-29 09:01:48.97 server process_loginread: Process 1340
generated
> > > fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > > terminating this process.

****************************************************************************

- Show quoted text -

> > > ***

> > > *

> > > * BEGIN STACK DUMP:

> > > * 01/29/03 09:01:48 spid 0

> > > *

> > > * Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
> > > 3414+00000003)

> > > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

> > > * Access Violation occurred writing address 4107160C

> > > *

> > > * MODULE BASE END SIZE

> > > * sqlservr 00400000 00B19FFF 0071a000

> > > * ntdll 77F80000 77FFAFFF 0007b000

> > > * KERNEL32 77E80000 77F30FFF 000b1000

> > > * ADVAPI32 77DB0000 77E0AFFF 0005b000

> > > * RPCRT4 77D30000 77DA0FFF 00071000

> > > * USER32 77E10000 77E6EFFF 0005f000

> > > * GDI32 77F40000 77F78FFF 00039000

> > > * OPENDS60 41060000 41065FFF 00006000

> > > * MSVCRT 78000000 78045FFF 00046000

> > > * UMS 41070000 4107CFFF 0000d000

> > > * SQLSORT 42AE0000 42B6FFFF 00090000

> > > * MSVCIRT 780A0000 780B1FFF 00012000

> > > * sqlevn70 41080000 41086FFF 00007000

> > > * NETAPI32 75170000 751BEFFF 0004f000

> > > * Secur32 77BE0000 77BEEFFF 0000f000

> > > * NETRAP 751C0000 751C5FFF 00006000

> > > * SAMLIB 75150000 7515FFFF 00010000

> > > * WS2_32 75030000 75042FFF 00013000

> > > * WS2HELP 75020000 75027FFF 00008000

> > > * WLDAP32 77950000 77977FFF 00028000

> > > * DNSAPI 77980000 779A3FFF 00024000

> > > * WSOCK32 75050000 75057FFF 00008000

> > > * wmi 76110000 76113FFF 00004000

> > > * ole32 77A50000 77B44FFF 000f5000

> > > * XOLEHLP 65450000 65457FFF 00008000

> > > * MSDTCPRX 6DF80000 6E032FFF 000b3000

> > > * MTXCLU 6A7A0000 6A7AFFFF 00010000

> > > * VERSION 77820000 77826FFF 00007000

> > > * LZ32 759B0000 759B5FFF 00006000

> > > * CLUSAPI 73930000 7393FFFF 00010000

> > > * RESUTILS 689D0000 689DCFFF 0000d000

> > > * USERENV 77C10000 77C6CFFF 0005d000

> > > * rnr20 782C0000 782CBFFF 0000c000

> > > * iphlpapi 77340000 77352FFF 00013000

> > > * ICMP 77520000 77524FFF 00005000

> > > * MPRAPI 77320000 77336FFF 00017000

> > > * OLEAUT32 779B0000 77A4AFFF 0009b000

> > > * ACTIVEDS 773B0000 773DDFFF 0002e000

> > > * ADSLDPC 77380000 773A1FFF 00022000

> > > * RTUTILS 77830000 7783DFFF 0000e000

> > > * SETUPAPI 77880000 7790CFFF 0008d000

> > > * RASAPI32 774E0000 77511FFF 00032000

> > > * RASMAN 774C0000 774D0FFF 00011000

> > > * TAPI32 77530000 77551FFF 00022000

> > > * COMCTL32 716F0000 71779FFF 0008a000

> > > * SHLWAPI 70BD0000 70C1BFFF 0004c000

> > > * DHCPCSVC 77360000 77378FFF 00019000

> > > * winrnr 777E0000 777E7FFF 00008000

> > > * rasadhlp 777F0000 777F4FFF 00005000

> > > * SSNETLIB 42CF0000 42D04FFF 00015000

> > > * SSNMPN70 410D0000 410D5FFF 00006000

> > > * security 75500000 75503FFF 00004000

> > > * msafd 74FD0000 74FECFFF 0001d000

> > > * wshtcpip 75010000 75016FFF 00007000

> > > * SSmsLPCn 42CD0000 42CD6FFF 00007000

> > > * ntdsapi 77BF0000

...

read more »

 
 
 

Can not start SQL server and server agent

Post by Ramesh Singh[MSFT » Thu, 30 Jan 2003 23:39:45


Julie,

    My guess is your SP2 upgrade never completed since the server is still
reporting build 194 in the errorlog. Also noticed that this the 10th dump;
hope you are aware of the earlier ones. can you check that the log from
applying SP2 did not have any errors.
--
Ramesh Singh

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

-----Original Message----- sent to rame...@microsoft.com

From: Shi, Xiaomei(Julie) (Xiaomei(Julie)) [mailto:julie...@lucent.com]

Sent: Wednesday, January 29, 2003 11:51 AM

To: Ramesh Singh

Subject: Re: Can not start SQL server and server agent

The file version for sqlservr.exe is 8.00.194. (in C:\Program
Files\Microsoft SQL Server\MSSQL\Binn)

The file version for ssnetlib.dll in the install path (C:\Program
Files\Microsoft SQL Server\MSSQL\Binn) is 8.00.636 after apply the hot fix.

The ssnetlib.phd in the install path (C:\Program Files\Microsoft SQL

Server\MSSQL\Binn\exe) is dated 6/3/2002.

"Ramesh Singh[MSFT]" <rame...@microsoft.com> wrote in message
news:uxcpXi8xCHA.2512@TK2MSFTNGP11...
> I noticed that the log is reflecting that your are still on SQL 2000 RTM
> release (build 194); SP2 is build 534

> --
> Ramesh Singh

> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm.
> "Jasper Smith" <jasper_smi...@hotmail.com> wrote in message
> news:uDLxSs7xCHA.1900@TK2MSFTNGP10...
> > What are the file versions of sqlservr.exe and ssnetlib.dll ?

> > --
> > HTH

> > Jasper Smith (SQL Server MVP)

> > I support PASS - the definitive, global
> > community for SQL Server professionals -
> > http://www.sqlpass.org

> > "Julie Shi" <Julie...@Lucent.com> wrote in message
> > news:#YXE076xCHA.1928@TK2MSFTNGP10...
> > Hi,

> > I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I
> installed
> > the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

> > Then I found the MQSQLSERVER and SQL server agent services can not be
> > started.

> > At the beginning, the SQL server service was started, but the server
agent
> > could not be started. The errorlog file is attached: errorlog - no
server
> > agent.txt.

> > Then my PC was restarted by itself. After that both SQL server and SQL
> > server agent could not be started. errorlog file attached: errorlog - no
> > server.txt.

> > Could someone tell me why?

> > Julie

> > ==================================================

> > errorlog - no server.txt:

> > 2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194
(Intel
> > X86)

> > Aug 6 2000 00:57:48

> > Copyright (c) 1988-2000 Microsoft Corporation

> > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > 2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft
> Corporation.

> > 2003-01-29 09:15:52.88 server All rights reserved.

> > 2003-01-29 09:15:52.88 server Server Process ID is 752.

> > 2003-01-29 09:15:52.88 server Logging SQL Server messages in file
> > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > 2003-01-29 09:15:53.28 server SQL Server is starting at priority class
> > 'normal'(1 CPU detected).

> > 2003-01-29 09:15:53.39 server SQL Server configured for thread mode
> > processing.

> > 2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500] Lock
> > Blocks, [5000] Lock Owner Blocks.

> > 2003-01-29 09:15:53.42 server Attempting to initialize Distributed
> > Transaction Coordinator.

> > 2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

> > 2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

> > 2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

> > 2003-01-29 09:15:55.62 server Operating system error 0: The operation
> > completed successfully...

> > 2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server
shutting
> > down.

> > =====================================================================

> > errorlog - no server agent.txt:

> > 2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194
(Intel
> > X86)

> > Aug 6 2000 00:57:48

> > Copyright (c) 1988-2000 Microsoft Corporation

> > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > 2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft
> Corporation.

> > 2003-01-29 09:00:40.65 server All rights reserved.

> > 2003-01-29 09:00:40.65 server Server Process ID is 796.

> > 2003-01-29 09:00:40.65 server Logging SQL Server messages in file
> > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > 2003-01-29 09:00:41.78 server SQL Server is starting at priority class
> > 'normal'(1 CPU detected).

> > 2003-01-29 09:00:46.36 server SQL Server configured for thread mode
> > processing.

> > 2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500] Lock
> > Blocks, [5000] Lock Owner Blocks.

> > 2003-01-29 09:00:49.30 server Attempting to initialize Distributed
> > Transaction Coordinator.

> > 2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

> > 2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

> > 2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

> > 2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

> > 2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40:
> 1433.

> > 2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

> > 2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

> > 2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

> > 2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

> > 2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

> > 2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

> > 2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

> > 2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared
Memory,
> > Named Pipes.

> > 2003-01-29 09:01:09.43 server SQL Server is ready for client connections

> > 2003-01-29 09:01:11.14 spid3 Recovery complete.

> > 2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

> > Stack Dump being sent to C:\Program Files\Microsoft SQL
> > Server\MSSQL\log\SQL00010.dmp

> > 2003-01-29 09:01:48.97 server process_loginread: Process 1340 generated
> > fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > terminating this process.

****************************************************************************
> > ***

> > *

> > * BEGIN STACK DUMP:

> > * 01/29/03 09:01:48 spid 0

> > *

> > * Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
> > 3414+00000003)

> > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

> > * Access Violation occurred writing address 4107160C

> > *

> > * MODULE BASE END SIZE

> > * sqlservr 00400000 00B19FFF 0071a000

> > * ntdll 77F80000 77FFAFFF 0007b000

> > * KERNEL32 77E80000 77F30FFF 000b1000

> > * ADVAPI32 77DB0000 77E0AFFF 0005b000

> > * RPCRT4 77D30000 77DA0FFF 00071000

> > * USER32 77E10000 77E6EFFF 0005f000

> > * GDI32 77F40000 77F78FFF 00039000

> > * OPENDS60 41060000 41065FFF 00006000

> > * MSVCRT 78000000 78045FFF 00046000

> > * UMS 41070000 4107CFFF 0000d000

> > * SQLSORT 42AE0000 42B6FFFF 00090000

> > * MSVCIRT 780A0000 780B1FFF 00012000

> > * sqlevn70 41080000 41086FFF 00007000

> > * NETAPI32 75170000 751BEFFF 0004f000

> > * Secur32 77BE0000 77BEEFFF 0000f000

> > * NETRAP 751C0000 751C5FFF 00006000

> > * SAMLIB 75150000 7515FFFF 00010000

> > * WS2_32 75030000 75042FFF 00013000

> > * WS2HELP 75020000 75027FFF 00008000

> > * WLDAP32 77950000 77977FFF 00028000

> > * DNSAPI 77980000 779A3FFF 00024000

> > * WSOCK32 75050000 75057FFF 00008000

> > * wmi 76110000 76113FFF 00004000

> > * ole32 77A50000 77B44FFF 000f5000

> > * XOLEHLP 65450000 65457FFF 00008000

> > * MSDTCPRX 6DF80000 6E032FFF 000b3000

> > * MTXCLU 6A7A0000 6A7AFFFF 00010000

> > * VERSION 77820000 77826FFF 00007000

> > * LZ32 759B0000 759B5FFF 00006000

> > * CLUSAPI 73930000 7393FFFF 00010000

> > * RESUTILS 689D0000 689DCFFF 0000d000

> > * USERENV 77C10000 77C6CFFF 0005d000

> > * rnr20 782C0000 782CBFFF 0000c000

> > * iphlpapi 77340000 77352FFF 00013000

> > * ICMP 77520000 77524FFF 00005000

> > * MPRAPI 77320000 77336FFF 00017000

> > * OLEAUT32 779B0000 77A4AFFF 0009b000

> > * ACTIVEDS 773B0000 773DDFFF 0002e000

> > * ADSLDPC 77380000 773A1FFF 00022000

> > * RTUTILS 77830000 7783DFFF 0000e000

> > * SETUPAPI 77880000 7790CFFF 0008d000

> > * RASAPI32 774E0000 77511FFF 00032000

> > * RASMAN 774C0000 774D0FFF 00011000

> > * TAPI32 77530000 77551FFF 00022000

> > * COMCTL32 716F0000 71779FFF 0008a000

> > * SHLWAPI 70BD0000 70C1BFFF 0004c000

> > * DHCPCSVC 77360000 77378FFF 00019000

> > * winrnr 777E0000 777E7FFF 00008000

> > * rasadhlp 777F0000 777F4FFF 00005000

> > * SSNETLIB 42CF0000 42D04FFF 00015000

> > * SSNMPN70 410D0000 410D5FFF 00006000

> > * security 75500000 75503FFF 00004000

> > * msafd 74FD0000 74FECFFF 0001d000

> > * wshtcpip 75010000 75016FFF 00007000

> > * SSmsLPCn 42CD0000 42CD6FFF 00007000

> > * ntdsapi 77BF0000 77C00FFF 00011000

> > * sqlimage 4A400000 4A40CFFF 0000d000

> > * DBGHELP 2ACF0000 2AD02FFF 00013000

> > *

> > * Edi: 194FE3F8: 00000000 194FFFF0 00000001 10000008 194FE018 194FFFF0

> > * Esi: 194FE090: 194FE3F8 00000000 00000002 00030308 194FE030 00000000

> > * Eax: 29974270: FFFF0002 00000000 00000000 00000000

...

read more »

 
 
 

Can not start SQL server and server agent

Post by Jasper Smit » Fri, 31 Jan 2003 00:42:53


The problem is that the server was not at SP2 level
when the hotfix was applied. The use of ssnetlib.dll
version 8.00.636 with SQL Server at less than SP2
will cause access violations when any login is attempted
(I tested this during the slammer troubles and whilst in
my case SQL Server started, all connection attempts
caused an AV and an NT event log error that mentions
process_loginread which I can see in your dump file)
If you revert ssnetlib.dll back to the one from the original
install CD and then try reapplying SP2 and confirming it's
on before trying to apply the hotfix.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

"Julie Shi" <Julie...@Lucent.com> wrote in message

news:eVC7$#8xCHA.2916@TK2MSFTNGP09...
> The file version for sqlservr.exe is 8.00.194. (in C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn)

> The file version for ssnetlib.dll in the install path (C:\Program
> Files\Microsoft SQL Server\MSSQL\Binn) is 8.00.636 after apply the hot
fix.

> The ssnetlib.phd in the install path (C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\exe) is dated 6/3/2002.

> "Ramesh Singh[MSFT]" <rame...@microsoft.com> wrote in message
> news:uxcpXi8xCHA.2512@TK2MSFTNGP11...
> > I noticed that the log is reflecting that your are still on SQL 2000 RTM
> > release (build 194); SP2 is build 534

> > --
> > Ramesh Singh

> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > Use of included script samples are subject to the terms specified at
> > http://www.microsoft.com/info/cpyright.htm.
> > "Jasper Smith" <jasper_smi...@hotmail.com> wrote in message
> > news:uDLxSs7xCHA.1900@TK2MSFTNGP10...
> > > What are the file versions of sqlservr.exe and ssnetlib.dll ?

> > > --
> > > HTH

> > > Jasper Smith (SQL Server MVP)

> > > I support PASS - the definitive, global
> > > community for SQL Server professionals -
> > > http://www.sqlpass.org

> > > "Julie Shi" <Julie...@Lucent.com> wrote in message
> > > news:#YXE076xCHA.1928@TK2MSFTNGP10...
> > > Hi,

> > > I have SQL 2000 server on my PC. To avoid W32/SQL Slammer Worm, I
> > installed
> > > the sql2ksp2.exe and applied the hot fix Q323875_SQL2000_SP2_EN.EXE.

> > > Then I found the MQSQLSERVER and SQL server agent services can not be
> > > started.

> > > At the beginning, the SQL server service was started, but the server
> agent
> > > could not be started. The errorlog file is attached: errorlog - no
> server
> > > agent.txt.

> > > Then my PC was restarted by itself. After that both SQL server and SQL
> > > server agent could not be started. errorlog file attached: errorlog -
no
> > > server.txt.

> > > Could someone tell me why?

> > > Julie

> > > ==================================================

> > > errorlog - no server.txt:

> > > 2003-01-29 09:15:52.88 server Microsoft SQL Server 2000 - 8.00.194
> (Intel
> > > X86)

> > > Aug 6 2000 00:57:48

> > > Copyright (c) 1988-2000 Microsoft Corporation

> > > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > > 2003-01-29 09:15:52.88 server Copyright (C) 1988-2000 Microsoft
> > Corporation.

> > > 2003-01-29 09:15:52.88 server All rights reserved.

> > > 2003-01-29 09:15:52.88 server Server Process ID is 752.

> > > 2003-01-29 09:15:52.88 server Logging SQL Server messages in file
> > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > > 2003-01-29 09:15:53.28 server SQL Server is starting at priority class
> > > 'normal'(1 CPU detected).

> > > 2003-01-29 09:15:53.39 server SQL Server configured for thread mode
> > > processing.

> > > 2003-01-29 09:15:53.40 server Using dynamic lock allocation. [2500]
Lock
> > > Blocks, [5000] Lock Owner Blocks.

> > > 2003-01-29 09:15:53.42 server Attempting to initialize Distributed
> > > Transaction Coordinator.

> > > 2003-01-29 09:15:55.62 server Error: 17822, Severity: 16, State: 1

> > > 2003-01-29 09:15:55.62 server Could not load Net-Library 'SSNETLIB'..

> > > 2003-01-29 09:15:55.62 server Error: 17059, Severity: 18, State: 0

> > > 2003-01-29 09:15:55.62 server Operating system error 0: The operation
> > > completed successfully...

> > > 2003-01-29 09:15:55.62 server Unable to load any NETLIBs. Server
> shutting
> > > down.

> > > =====================================================================

> > > errorlog - no server agent.txt:

> > > 2003-01-29 09:00:40.54 server Microsoft SQL Server 2000 - 8.00.194
> (Intel
> > > X86)

> > > Aug 6 2000 00:57:48

> > > Copyright (c) 1988-2000 Microsoft Corporation

> > > Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

> > > 2003-01-29 09:00:40.65 server Copyright (C) 1988-2000 Microsoft
> > Corporation.

> > > 2003-01-29 09:00:40.65 server All rights reserved.

> > > 2003-01-29 09:00:40.65 server Server Process ID is 796.

> > > 2003-01-29 09:00:40.65 server Logging SQL Server messages in file
> > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.

> > > 2003-01-29 09:00:41.78 server SQL Server is starting at priority class
> > > 'normal'(1 CPU detected).

> > > 2003-01-29 09:00:46.36 server SQL Server configured for thread mode
> > > processing.

> > > 2003-01-29 09:00:46.55 server Using dynamic lock allocation. [2500]
Lock
> > > Blocks, [5000] Lock Owner Blocks.

> > > 2003-01-29 09:00:49.30 server Attempting to initialize Distributed
> > > Transaction Coordinator.

> > > 2003-01-29 09:00:52.78 spid3 Starting up database 'master'.

> > > 2003-01-29 09:00:58.03 server Using 'SSNETLIB.DLL' version '8.0.636'.

> > > 2003-01-29 09:00:58.03 spid5 Starting up database 'model'.

> > > 2003-01-29 09:00:59.26 spid3 Server name is 'JULIESHI-1'.

> > > 2003-01-29 09:00:59.26 server SQL server listening on 135.185.163.40:
> > 1433.

> > > 2003-01-29 09:00:59.26 server SQL server listening on 127.0.0.1: 1433.

> > > 2003-01-29 09:01:00.04 spid8 Starting up database 'msdb'.

> > > 2003-01-29 09:01:00.04 spid9 Starting up database 'pubs'.

> > > 2003-01-29 09:01:00.14 spid10 Starting up database 'Northwind'.

> > > 2003-01-29 09:01:00.14 spid11 Starting up database 'EpochWeb'.

> > > 2003-01-29 09:01:01.57 spid5 Clearing tempdb database.

> > > 2003-01-29 09:01:09.03 spid5 Starting up database 'tempdb'.

> > > 2003-01-29 09:01:09.43 server SQL server listening on TCP, Shared
> Memory,
> > > Named Pipes.

> > > 2003-01-29 09:01:09.43 server SQL Server is ready for client
connections

> > > 2003-01-29 09:01:11.14 spid3 Recovery complete.

> > > 2003-01-29 09:01:45.55 server Using 'sqlimage.dll' version '4.0.5'

> > > Stack Dump being sent to C:\Program Files\Microsoft SQL
> > > Server\MSSQL\log\SQL00010.dmp

> > > 2003-01-29 09:01:48.97 server process_loginread: Process 1340
generated
> > > fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
> > > terminating this process.

****************************************************************************

- Show quoted text -

> > > ***

> > > *

> > > * BEGIN STACK DUMP:

> > > * 01/29/03 09:01:48 spid 0

> > > *

> > > * Exception Address = 42CF3DD4 (_ConnectionReadAsync + 0000001D Line
> > > 3414+00000003)

> > > * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

> > > * Access Violation occurred writing address 4107160C

> > > *

> > > * MODULE BASE END SIZE

> > > * sqlservr 00400000 00B19FFF 0071a000

> > > * ntdll 77F80000 77FFAFFF 0007b000

> > > * KERNEL32 77E80000 77F30FFF 000b1000

> > > * ADVAPI32 77DB0000 77E0AFFF 0005b000

> > > * RPCRT4 77D30000 77DA0FFF 00071000

> > > * USER32 77E10000 77E6EFFF 0005f000

> > > * GDI32 77F40000 77F78FFF 00039000

> > > * OPENDS60 41060000 41065FFF 00006000

> > > * MSVCRT 78000000 78045FFF 00046000

> > > * UMS 41070000 4107CFFF 0000d000

> > > * SQLSORT 42AE0000 42B6FFFF 00090000

> > > * MSVCIRT 780A0000 780B1FFF 00012000

> > > * sqlevn70 41080000 41086FFF 00007000

> > > * NETAPI32 75170000 751BEFFF 0004f000

> > > * Secur32 77BE0000 77BEEFFF 0000f000

> > > * NETRAP 751C0000 751C5FFF 00006000

> > > * SAMLIB 75150000 7515FFFF 00010000

> > > * WS2_32 75030000 75042FFF 00013000

> > > * WS2HELP 75020000 75027FFF 00008000

> > > * WLDAP32 77950000 77977FFF 00028000

> > > * DNSAPI 77980000 779A3FFF 00024000

> > > * WSOCK32 75050000 75057FFF 00008000

> > > * wmi 76110000 76113FFF 00004000

> > > * ole32 77A50000 77B44FFF 000f5000

> > > * XOLEHLP 65450000 65457FFF 00008000

> > > * MSDTCPRX 6DF80000 6E032FFF 000b3000

> > > * MTXCLU 6A7A0000 6A7AFFFF 00010000

> > > * VERSION 77820000 77826FFF 00007000

> > > * LZ32 759B0000 759B5FFF 00006000

> > > * CLUSAPI 73930000 7393FFFF 00010000

> > > * RESUTILS 689D0000 689DCFFF 0000d000

> > > * USERENV 77C10000 77C6CFFF 0005d000

> > > * rnr20 782C0000 782CBFFF 0000c000

> > > * iphlpapi 77340000 77352FFF 00013000

> > > * ICMP 77520000 77524FFF 00005000

> > > * MPRAPI 77320000 77336FFF 00017000

> > > * OLEAUT32 779B0000 77A4AFFF 0009b000

> > > * ACTIVEDS 773B0000 773DDFFF 0002e000

> > > * ADSLDPC 77380000 773A1FFF 00022000

> > > * RTUTILS 77830000 7783DFFF 0000e000

> > > * SETUPAPI 77880000 7790CFFF 0008d000

> > > * RASAPI32 774E0000 77511FFF 00032000

> > > * RASMAN 774C0000 774D0FFF 00011000

> > > * TAPI32 77530000 77551FFF 00022000

> > > * COMCTL32 716F0000 71779FFF 0008a000

> > > * SHLWAPI 70BD0000 70C1BFFF 0004c000

> > > * DHCPCSVC 77360000 77378FFF 00019000

> > > * winrnr 777E0000

...

read more »

 
 
 

1. SQLServer Agent NOT starting after upgr frm SQL Server 7.0 to SQL Server 2K

hi,
SQL Server 7.0 was running fine and was accessible by all
my applications. After upgrade to SQL Server 2000, the
SQLServer Agent is refusing to start. Infact, it starts
and stops IMMEDIATELY as is reflected in the Win2K
Services (Start from Services and refresh)

SQLAgent.OUT contains the following entries :
1. [298]SQL Server Error: 1311, Cannot generate SSPI
Context [SQLSTATE HY000]
2. [000] Unable to connect to SQL Server '[local]'; Cannot
start SQLServer Agent

The current setup is
x86 2 CPU
1GB RAM
NT4.0 upgraded to Win2K (No SP set up yet .... could this
be the reason ???)
SQL Server 7.0 EE upgraded to SQL Server 2000 EE witt SP1.
Connection to DB thro' Windows authentication.
Query Analyzer works fine ..... not checked out other apps.

Any ideas ???

2. RAW partitions on Linux

3. SQL server Agent can not autostart when SQL server 7 start

4. ODBC Connectivity Issue - Error Number: 0x80040000

5. can not start SQL server and server agent service

6. Q: How to access NT SQL Server from Sun Workstation?

7. MS SQL Server Agent Could Not Start In Cluster Server

8. HELP! Total problem

9. Cannot Start SQL Server Agent on SQL Server 7 after Upgrade

10. SQL Server Agent not starting

11. sql server agent service not started

12. SQL Server Agent Does not want to start

13. SQL server agent does not start