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

  • October 19, 2009 at 10:34 am

    #1067749

    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?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass