[dba-SQLServer]Who can Stop SQL Server?

Billy Pang tuxedo_man at hotmail.com
Wed Sep 17 18:23:40 CDT 2003


SS2K is using mixed security.
I am positive the user does not belong to any of the server admin groups 
directly or indirectly.


>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 16:51:01 -0500
>
>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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

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



More information about the dba-SQLServer mailing list