Re: 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:57:42 -0800


No, the problem is still not resolved. Here is the event
log for your info. 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-----
>Let us know if your problem wasn't solved by the above
suggestion.
>
>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.
>"Sean" <ssullivan@aaf.org> wrote in message
>news:05d101c2c7b1$6ebb9080$89f82ecf@TK2MSFTNGXA01...
>> 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: 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)
  • SQL Service Not Starting
    ... Event Type: Information ... Event Source: MSSQLSERVER ... SQL Server is starting at priority class 'normal'(2 CPUs ...
    (microsoft.public.sqlserver.security)
  • 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)