[dba-SQLServer]Who can Stop SQL Server?

Billy Pang tuxedo_man at hotmail.com
Wed Sep 17 16:37:26 CDT 2003


That is what I thought.  Maybe something is not right.

For some reason, via EM, the sa user cannot stop the SQL Server service from 
a remote machine (I get an access denied message).

Also, a user that does not belong to server or system admin fixed role can 
stop the SQL Service service via EM if on the same machine.

Any ideas?

Thanks
Billy


>From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]Who can Stop SQL Server?
>Date: Wed, 17 Sep 2003 15:54:36 -0500
>
>Server administrator and system administrator roles.
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy
>Pang
>Sent: Wednesday, September 17, 2003 3:32 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]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
>
>_________________________________________________________________
>MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
>http://join.msn.com/?page=features/virus
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail



More information about the dba-SQLServer mailing list