[dba-SQLServer]Who can Stop SQL Server?

Do you have Builtin Administrators assigned sysadmin?  Are there any
other groups that belong to sysadmin or server admin groups?  SA will
fail to do anything if authentication is windows only.

-----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 4:37 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Who can Stop SQL Server?


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

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com