SQL Service Not Starting

From: Adam (adam_shafiullah@hotmail.com)
Date: 01/30/03


From: "Adam" <adam_shafiullah@hotmail.com>
Date: Wed, 29 Jan 2003 20:59:08 -0800


I have tried the full reboot several times. It didn't
help. Here is the event log. Any help is appreciated.

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 1/30/2003
Time: 12:20:26 AM
User: N/A
Computer: KSPHC
Description:
17125 :
Using dynamic lock allocation. [2500] Lock Blocks, [5000]
Lock Owner Blocks.

Data:
0000: e5 42 00 00 0a 00 00 00 åB......
0008: 06 00 00 00 4b 00 53 00 ....K.S.
0010: 50 00 48 00 43 00 00 00 P.H.C...
0018: 00 00 00 00 ....

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

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 1/30/2003
Time: 12:20:26 AM
User: N/A
Computer: KSPHC
Description:
17124 :
SQL Server configured for thread mode processing.

Data:
0000: e4 42 00 00 0a 00 00 00 äB......
0008: 06 00 00 00 4b 00 53 00 ....K.S.
0010: 50 00 48 00 43 00 00 00 P.H.C...
0018: 00 00 00 00 ....

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

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 1/30/2003
Time: 12:20:26 AM
User: N/A
Computer: KSPHC
Description:
17162 :
SQL Server is starting at priority class 'normal'(2 CPUs
detected).

Data:
0000: 0a 43 00 00 0a 00 00 00 .C......
0008: 06 00 00 00 4b 00 53 00 ....K.S.
0010: 50 00 48 00 43 00 00 00 P.H.C...
0018: 00 00 00 00 ....
----------------------------
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 1/30/2003
Time: 12:20:26 AM
User: N/A
Computer: KSPHC
Description:
17052 :
Microsoft SQL Server 2000 - 8.00.428 (Intel X86)
Aug 7 2001 04:27:51
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service
Pack 3)

Data:
0000: 9c 42 00 00 0a 00 00 00 ?B......
0008: 06 00 00 00 4b 00 53 00 ....K.S.
0010: 50 00 48 00 43 00 00 00 P.H.C...
0018: 00 00 00 00 ....

>-----Original Message-----
>Are you trying to start the SQL services though Services?
>Have you tried a full reboot of the machine. I had a
>similar problem and restarting the machine took care of
>the problem when Services in Control panel wouldn't.
>
>Good Luck!
>
>
>>-----Original Message-----
>>Dear All,
>>
>>Need Help!!!!!!!!!!!
>>
>>We were running SP2 on SQl 8.00.760 and we got hit on
>>25th. We applied hot fix 8.00.636 from microsoft
>>immediately and applied sp3 on 27th. Everything seemed
>>working OK except today (29th Jan 2003) at 2 PM the SQL
>>service would not start. We are trying desperately to
>>start the service. Any help is welcome.
>>.
>>
>.
>



Relevant Pages

  • Re: SQL Service Not Starting
    ... Event Type: Information ... Event Source: MSSQLSERVER ... SQL Server is starting at priority class 'normal'(2 CPUs ...
    (microsoft.public.sqlserver.security)
  • Re: Starting SQL Server Resource Group failed
    ... The installation of the Virtual SQL Server 2005 went well, ... If I want to bring the Resource Group online, the SQL Server Starts, but a ... Event Source: SQLBrowser ... Event Type: Information ...
    (microsoft.public.sqlserver.clustering)
  • Cluster resource SQL Server Fulltext in Resource Group SERVER failed.
    ... Event Type: Error ... Event Source: ClusSvc ... Cluster resource 'SQL Server Fulltext' in Resource Group 'SQL1' failed. ...
    (microsoft.public.sqlserver.clustering)
  • Errors in Event Log
    ... Event Type: Error ... Event Source: MSSQLSERVER ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.server)
  • SuperSocket Warning
    ... I am getting the following warning everytime SQL Server starts up (on ... Event Type: Warning ... Event Source: MSSQLServer ...
    (microsoft.public.sqlserver.server)