Link to home
Start Free TrialLog in
Avatar of NoraWil
NoraWilFlag for Belgium

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of kaminda
kaminda
Flag of Sri Lanka image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial