Post reply

HELP - SQL WILL NOT START

  • October 22, 2007 at 3:16 am

    #76803

    runing Windows 2003 SP1, SQL Server 2000 SP4 (8.00.2187).SQL service will not start after server reboot. returns error :

    Could not start the MSSQLSERVER service on local computer

    Error 1053: The service did not respond to the start or control request in a timely fashion.

    It returns this error immediately, does not even take time to think about it, although eventvwr says it timesout after 30 secs (not true!)

    Any ideas?

    cheer

    george

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

  • October 22, 2007 at 3:22 am

    #744042

    Hi,

    Can this help ? You may need to install a Service Pack to fix it.

    http://support.microsoft.com/kb/839174

    Osama

  • October 22, 2007 at 3:27 am

    #744044

    probably not osama, I get the error on trying to start the service , rather than stop.

    I shouyld add there were space problems on the drive the day before, but these were cleared before server restarted.

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

  • October 22, 2007 at 3:43 am

    #744047

    Tryinf to start SQL from command line not under a service (sqlservr.exe -c) I get the following error:

    Application popup: sqlservr.exe - Unable To Locate Component : This application has failed to start because MSVCP71.dll was not found. Re-installing the application may fix this problem.

    sounds like a reinstall?

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

  • October 22, 2007 at 4:20 am

    #744056

    Panic over, copied over file MSVCP71.dll from another 2003 server (it can also be downloaded from web) and it all started fine.

    So trying to start it without service gave the clue to problem.

    hope this helps someone else sometime

    george

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

  • November 2, 2009 at 12:11 pm

    #1073949

    Thanks for posting your solution!

    We had a server with 2 SQL Server instances and were experiencing Error 1053 on one instance when trying to start it.

    Copying MSVCP71.dll from another 2003 server as per the above post seemed to fix everything...

  • November 2, 2009 at 12:19 pm

    #1073951

    Thats good to know. Pure coincidence I logged into active threads and this came up top of the list!

    🙂

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

  • November 2, 2009 at 1:19 pm

    #1073962

    Glad you were able to resolve your issue and posted what you did to solve it as well. Looks like it will benefit others. 🙂

  • March 30, 2010 at 8:15 am

    #1142237

    MSVCP71.dll is also on the SQL Server 2000 SP4 CD. Copying it into the system32 folder worked without having to register it. That is, as soon as I copied the file I could start the SQL service. Thanks for the solution.

  • March 30, 2010 at 8:24 am

    #1142253

    my pleasure.

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

  • June 13, 2011 at 1:40 am

    #1337602

    thanks for solution,

    I am using sql server 2000 on windows 2003 64bit, I copied, MSVCR71.DLL and msvcp71.dll files into following path

    C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn

    after copying dll files sql server run successfully

    I got these files from sql server sp4 cd

    🙂

    Thanks

  • June 14, 2011 at 3:05 am

    #1338229

    the topic that just keeps on giving 🙂

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

Viewing 12 posts - 1 through 11 (of 11 total)

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