Who can Stop SQL Server?
-
Just wondering, what permission/role governs whether or not a user can stop the SQL Server service?
Thanks in advance,
Billy
-
NO ONE CAN STOP SQL SERVER!!!!!!
Anyone that can stop services (usually admins) can stop the service.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
Yes. You should have Local Admin Access on the BOX.
.
-
Ok I'll do it ...
You can't stop the Server
nobody can stop the Server.
Take the cold from the snow
tell the trees "don't grow"
Tell the wind "don't blow"
'cause it's easier no!
You can't stop the Server
nobody can stop the Server.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
-
Members of the sysadmin and serveradmin fixed server roles can stop the services using the SHUTDOWN command from within a query. By default, members of the local Administrators group on the server are added to the sysadmin fixed server role and the serveradmin role has no members by default.
However, the services can also be stopped:
1. By using SQL Server Enterprise Manager.
2. By using net stop mssqlserver from a command prompt.
3. By using Services in Control Panel.
4. By using SQL Server Service Manager.
Theses methods all issue a SERVICE_CONTROL_STOP message to SQL Server. Can someone describe the security that is required to perform these actions ? I would guess that it is a User Rights Assignment option that can be assigned to different groups, but local Administrators have the right by default.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply