Home Forums SQL Server 7,2000 Administration Default instance stuck on starting RE: Default instance stuck on starting

  • October 19, 2009 at 10:42 am

    #1067755

    GilaMonster (10/19/2009)

    Adam Bean (10/19/2009)

    GilaMonster (10/19/2009)

    What happens if you try and start SQL from the command line? For the default instance, go to the directory with the executable and just run sqlservr.exe

    Hi Gila. It simply responds saying the service could not start. Yet when viewing the services, you'll see it sitting on "starting". Crazy huh?

    You're getting that when you start SQL as a standalone executable? did you use any command line switches when you ran sqlservr.exe?

    Actually, I had not tried callings sqlservr.exe until now. I just did (c:\program files\microsoft sql server\mssql\binn\sqlservr.exe) and got the following:

    "SQL Server could not find the default instance (MSSQLSERVER) - please specify the name of an existing instance on the invocation of sqlservr.exe. if you believe that your installation is ocrrupt or has been tampered with, uninstall then re-run setup to correct this problem."