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.