Post reply

unable to restart sql server

  • February 2, 2007 at 3:28 am

    #175054

    i manually restarted the sql server from sql server configuration manager

    the problem is that it stopped but didnt restart,

    if i start it manualy i got this error:

    so plz can anyone help on how i can restart it successfully?

     

    If something's hard to do, then it's not worth doing.

  • February 2, 2007 at 3:49 am

    #687349

    Please will you give the text of the error since the picture you posted is only visible to you.

    Thanks

    John

  • February 2, 2007 at 5:17 am

    #687368

    sorry didnt know that

    here is the error text:

    " the request failed or the service did not respond in a timley fashion.Consult the event log or other applicable error  log for details."

     

    If something's hard to do, then it's not worth doing.

  • February 2, 2007 at 5:34 am

    #687373

    Look in your windows eventlogs for application and system errors relating to the MSSQL service. This contains the clue to why it is not resarting.

  • February 2, 2007 at 5:38 am

    #687375

    can i ask where i find those?

    If something's hard to do, then it's not worth doing.

  • February 2, 2007 at 5:44 am

    #687379

    just type eventvwr.msc to bring ur event viewer where u can find the errors related to sql server service startup lok for the errors in application and system logs and for the type sql server and related service.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 2, 2007 at 6:35 am

    #687393

    2005-10-30 15:35:44.79 Server      Error: 17182, Severity: 16, State: 1.

    2005-10-30 15:35:44.79 Server      TDSSNIClient initialization failed with error 0xd, status code 0x36.

    2005-10-30 15:35:44.79 Server      Error: 17182, Severity: 16, State: 1.

    2005-10-30 15:35:44.79 Server      TDSSNIClient initialization failed with error 0xd, status code 0x1.

    2005-10-30 15:35:44.79 Server      Error: 17826, Severity: 18, State: 3.

    2005-10-30 15:35:44.79 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

    2005-10-30 15:35:44.79 Server      Error: 17120, Severity: 16, State: 1.

    2005-10-30 15:35:44.79 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

     

    The SQL Server Agent (MSSQLSERVER) service depends on the SQL Server (MSSQLSERVER) service which failed to start because of the following error:

    %%0

     

    these errors i found

    If something's hard to do, then it's not worth doing.

  • February 2, 2007 at 6:38 am

    #687394

    i did some research my own and i fixed the problem 10x all anyway.

    i Checked network protocols for SQL Server in the SQL Configuration Manager application. the VIA protocol was enabled so i had to disable it and then i restarted the SQL Server service .

    it worked

    If something's hard to do, then it's not worth doing.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply