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