Troubleshooting Problems with the Start, Stop and Pause Permission

I need to permit the DBAdmin account authority to start and stop the SQL Server service in Windows 2000. I used the Microsoft Management Console (MMC) Security Templates snap-in to create a security template that grants DBAdmin the Start, stop and pause permission on the service, but DBAdmin still isn't able to start or stop the service. What have I missed?

For the Start, stop and pause permission to take effect, you also need to grant the user Read access to the service. To start, stop, or pause a service, the MMC Services snap-in or the Net command first must be able to read certain service object properties. Editing the SQL Server service's ACL to allow Read access to DBAdmin will solve your problem.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.