Post reply

Stop and Start SQL Server

  • July 22, 2004 at 4:01 am

    #86165

    Hi all

    Is it possible to stop and start the SQL Server service when not logged onto your machine as Administrator?

    I have managed to stop the service using SQLDMO, but when I try to start it again I get a message saying Permission Denied.

    Is there such a thing as "Restart" in SQLDMO?

    Thanks for any advice

    Rob

  • July 22, 2004 at 6:43 am

    #515655

    You can try scm.exe. Check in BOL for parameters. You also have a Restart action and remote access.

     

  • July 22, 2004 at 7:46 am

    #515675

    The permissions to start SQL Server should come from the Windows service permissions. Stopping can come frmo SQL Server or Windows, depending on whether you can issue a stop command (shutdown) from inside the server or stop the windows service.

Viewing 3 posts - 1 through 3 (of 3 total)

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