Post reply

SQL Server Management Studio Starting SQL Server

  • June 21, 2007 at 5:45 am

    #174190

    Hello everyone.

    I have a question about granting enough rights to allow a non admin user to start and stop a sql server service via the SQL Server Management Studio by right clicking on the server node.

    I have changed the acl's of the SQL Server service security and gave the user rights to start and stop the service. This does allow them to connect remotly to the server using computer manager and they successifully start and stop the service. But, in SQL Server Management Studio the option still does not show up, unless he is a admin of the server.

    Does anyone know what other security settings I need to address for the start and stop to show up when I right click on the server node?

    Thanks for any help

  • June 21, 2007 at 6:02 am

    #714313

    Add the user to serveradmin role.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • June 21, 2007 at 6:21 am

    #714319

    Sorry I failed mention this but I already have them in sysadmin role. This is more to a issue with security on the server (windows 2003 server) rather then in sql server.

     

    Thanks

  • June 21, 2007 at 6:50 am

    #714329

    I was able to add the user to the Distributed COMN Users group and it started working.

    Thanks

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

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