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.

Answer 1

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

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 2

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

Answer 3

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.

Answer 4

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

Answer 5

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