Grant user permission to stop and start SQL server service
Posted on 2011-05-09
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.