• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 803
  • Last Modified:

Grant user permission to stop and start SQL server service

Hi Experts,
I want to give a collegue the right to stop and start the sql server service. I used the following command 'Exec sp_addsrvrolemember 'SBS\Evelyne', sysadmin' to add her to the administrators group, but in SQL Management Studio there is no green arrow showing the service is started. The options Start, Restart en Stop are still greyed out, so Evelyne is still not able to start en stop the SQL service. What should I do next.
As you probably already mentionned, I am a newbie in SQL server.
1 Solution
You can not give sevice start stop rights by using SQL Server internal security roles. The perticular user must have rights to that machine to start stop services. This has to be done through Active Directory.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now