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.
NoraWilAsked:
Who is Participating?
 
kamindaConnect With a Mentor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.