Re: sql server start/stop security

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/18/04

  • Next message: Rand Boyd [MSFT]: "RE: sql server start/stop security" 
    Date: Thu, 18 Nov 2004 08:51:50 -0700

    In addition to removing the other accounts from the local
    administrators group on the SQL Server box, users who are
    members of the sysadmin or serveradmin fixed server roles
    can execute SHUTDOWN or stop the service using Enterprise
    Manager.

    -Sue

    On Thu, 18 Nov 2004 06:43:07 -0800, dimsdale_007
    <dimsdale007@discussions.microsoft.com> wrote:

    >i have my sa account set as the one that starts/stops the server. however,
    >one of my admins logged onto another machine and stopped the server during
    >production! is there a way to restrict everyone from be able to log on the
    >machine, or remote into the machine and stop/start the service except for
    >myself?
    >
    >thanks,

  • Next message: Rand Boyd [MSFT]: "RE: sql server start/stop security"

    Relevant Pages

    • Re: Retrieve / list members of Sysadmin role without connecting to the SQL-server (API? Please help!
      ... change all security settings on SQL Server. ... about the members of the server roles with EXEC sp_helpsrvrolemember, ... I'm not too sure about that as I'm able to retrieve Windows ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL Profiler wont allow a developer to login
      ... I would have one of them to login using their windows account, open a query window and verify whether they are sysadmin. ... Tibor Karaszi, SQL Server MVP ... I have a SQL Server that is causing some issues when devleopers attempt to ...
      (microsoft.public.sqlserver.tools)
    • Re: Move or Setup of SQL Database toa Remote Server Fails
      ... both the SCCM Server name and the User Installing are members of the ... as well as have SysAdmin privileges on the DB. ... Could not connect SQL Server 'master' db. ... The SCCM Primary Site Computer Account and the User account I am using ...
      (microsoft.public.sms.setup)
    • Re: Domain user in SysAdmin Role (SQL Server on Windows Vista)
      ... you might also need to add the login before adding the login to the sysadmin server role: ... Following this instructions I try solve the authenticate problem in Windows Vista for SQL Server 2005: ... In my case the user account to add in sysadmin role is under a domain. ...
      (microsoft.public.sqlserver.security)
    • Re: SQL Server and Agent Accounts
      ... I log in to the server as a sysadmin. ... Here is a scenario that I tested: I created a Windows account called ... Apparently when SQL Agent logs in to the publisher it uses Domain\Maer. ...
      (microsoft.public.sqlserver.replication)