NoraWil
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.