locked
Non-admin Users SQL Server Configuration Manager RRS feed

  • Question

  • Hi Everyone,

    I'm wondering if it's possible to grant non-admin users to start/stop SQL services using SQL Server Configuration Manager. Using the sc command, I was able to grant non-admin users access to services applet in Windows.

    However, our DBA said that the best practice to stop/start SQL is via SQL Server Configuration Manager. Based on testing, they are unable to stop/start SQL from SQL Server Configuration Manager though they are able to do so (stop/start SQL services) via Services applet.

    Saturday, July 19, 2014 3:51 AM

Answers

  • Check these links.. Yes you can stop/start SQL is via SQL Server Configuration Manager, services.msc, SSMS --> InstanceName-->Stop / Start

    http://support.microsoft.com/kb/325349

    http://social.technet.microsoft.com/Forums/en/w7itprosecurity/thread/8848c72c-37fa-4d7f-90a6-769e4204f2f3


    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by Elvis Long Tuesday, July 29, 2014 8:46 AM
    Saturday, July 19, 2014 1:17 PM
  • However, our DBA said that the best practice to stop/start SQL is via SQL Server Configuration Manager. Based on testing, they are unable to stop/start SQL from SQL Server Configuration Manager though they are able to do so (stop/start SQL services) via Services applet.

    I'm not sure why your DBA advises using SQL Server Configuration Manager to simply stop and start services.  Other methods (SC, NET START/STOP, Services mmc) are also valid methods.  However, changes like the service account should be done using SSCM.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Saturday, July 19, 2014 3:12 PM

All replies

  • Check these links.. Yes you can stop/start SQL is via SQL Server Configuration Manager, services.msc, SSMS --> InstanceName-->Stop / Start

    http://support.microsoft.com/kb/325349

    http://social.technet.microsoft.com/Forums/en/w7itprosecurity/thread/8848c72c-37fa-4d7f-90a6-769e4204f2f3


    Raju Rasagounder Sr MSSQL DBA

    • Marked as answer by Elvis Long Tuesday, July 29, 2014 8:46 AM
    Saturday, July 19, 2014 1:17 PM
  • However, our DBA said that the best practice to stop/start SQL is via SQL Server Configuration Manager. Based on testing, they are unable to stop/start SQL from SQL Server Configuration Manager though they are able to do so (stop/start SQL services) via Services applet.

    I'm not sure why your DBA advises using SQL Server Configuration Manager to simply stop and start services.  Other methods (SC, NET START/STOP, Services mmc) are also valid methods.  However, changes like the service account should be done using SSCM.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    Saturday, July 19, 2014 3:12 PM