locked
security rights needed to Start and stop services from SQL Server Management Studio RRS feed

  • Question

  • 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

    Thursday, June 21, 2007 11:50 AM

Answers

  • I was able to add them to the Distributed COM Users group and it took care of the problem.
    Thursday, June 21, 2007 12:50 PM

All replies

  • I was able to add them to the Distributed COM Users group and it took care of the problem.
    Thursday, June 21, 2007 12:50 PM
  • Well something broke that and it no longer works.
    Wednesday, July 11, 2007 6:28 PM