0

Occasionally, our developers need to restart SQL services. We do not want said developers to be local admins on each server if not necessary. What is the minimum permission required so that the developers can restart the SQL Services (database engine and agent) remotely using SSMS? We use SQL Server 2008 R2 on Windows Server 2008 R2.

3

You can grant the Service Start/Stop right for the SQL Server and Agent service to the Developers or their Windows group.

You can use

  • Use Group Policy
  • Security Templates or
  • Use Subinacl.exe

Above all are described in this KB article How to grant users rights to manage services

As a side note, you can use sysinternals tool - accesschk.exe. It will help you to find out -

what kind of accesses specific users or groups have to resources including files, directories, Registry keys, global objects and Windows services.

  • Will the steps work the same for Server 2008? – Dave Johnson Apr 3 '14 at 21:36
  • Yes, it will work. check Security- The process is similar on other versions of Windows. – Kin Shah Apr 3 '14 at 21:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.