none
SQL server service start error 1053

    Question

  • I have SQL server 2005, (on server 2003 standard) when I try to start the service I get this error

    "could not start the SQL Server (MSSQLSERVER) service on the local computer. Error 1053: The service did not respond to the start or control request in a timely fashion."

    also this error in event viewer

    Timeout (30000 milliseconds) waiting for the SQL Server (MSSQLSERVER) service to connect.

    • Edited by Jeff_1 Saturday, March 3, 2012 8:15 AM
    Saturday, March 3, 2012 6:41 AM

Answers

  • Here is the solution

    1.ran process monitor http://technet.microsoft.com/en-us/sysinternals/bb896645

    2.Ran SQL service from command line (copied path and syntax from services properties)

    3. Saw this file location in process monitor running as the service attempted to run

    C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e69679\MSVCP80.dll

    4. opened that directory and noticed file size and date for MSVCP80.dll  was different then the one in SQL setup and install directory. So I replaced it

    The bad msvcp80.dll file is 542KB 7/12/2009

    The good file msvcp80.dll 536 KB 10/14/2005



    • Marked as answer by Jeff_1 Monday, March 5, 2012 4:35 PM
    • Edited by Jeff_1 Monday, March 5, 2012 4:53 PM
    Monday, March 5, 2012 4:31 PM

All replies

  • You wll find the reason in the SQL Server errorlog file (file named "errorlog").

    Tibor Karaszi, SQL Server MVP | web | blog

    Sunday, March 4, 2012 8:50 AM
  • I restarted SQL service on March 2nd and since then the log has no entrys since the service stopped. Because SQL service is not running. And will not start. I believe something is corrupt registry or file

    if I run the service command line

    "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER

    I get this

    The procedure entry point ??!$basic_ostream@DU$char_traits@D@std@@@std@@UAE@XZ could not be located in the dynamic link library MSVCP80.dll

    I might add what I think caused the problem is my bak files were writing to a USB drive it locked up, hanging up the back up jobs. I rebooted the USB drive and the jobs were still hung so I tried to  restart sql and it stopped but never started

    Thanks


    • Edited by Jeff_1 Sunday, March 4, 2012 4:53 PM
    Sunday, March 4, 2012 4:26 PM
  • Hi Jeff,

    Please try to restart your computer to see that it will work.


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

    Monday, March 5, 2012 2:44 AM
    Moderator
  • Disturbing... I would probably try some repair option (assuming such exists if you run setup again), and/or re-applying service pack. And last restort, reinstall. If restart doesn't sort this. And have ample of backups first, of course...

    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, March 5, 2012 8:09 AM
  • Here is the solution

    1.ran process monitor http://technet.microsoft.com/en-us/sysinternals/bb896645

    2.Ran SQL service from command line (copied path and syntax from services properties)

    3. Saw this file location in process monitor running as the service attempted to run

    C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e69679\MSVCP80.dll

    4. opened that directory and noticed file size and date for MSVCP80.dll  was different then the one in SQL setup and install directory. So I replaced it

    The bad msvcp80.dll file is 542KB 7/12/2009

    The good file msvcp80.dll 536 KB 10/14/2005



    • Marked as answer by Jeff_1 Monday, March 5, 2012 4:35 PM
    • Edited by Jeff_1 Monday, March 5, 2012 4:53 PM
    Monday, March 5, 2012 4:31 PM
  • where did you get the good file from???
    Tuesday, January 7, 2014 2:52 PM