New Sysadmin cannot stop SQL instance...

From: ABG (abimael.garcia_at_unisys.com)
Date: 07/15/03

  • Next message: Bill Cheng [MSFT]: "RE: How to create a trusted connection" 
    Date: Mon, 14 Jul 2003 15:35:06 -0700

    Currently, I'm running SQL Server 2000 on Windows 2000
    Advanced Server. I created a new Windows user who is not
    in the Administrators group. Then, I entered into the SQL
    instance's properties and changed the startup account to
    be this new user's credentials. As a result, SQL created a
    login for this new user and added him to the System
    Administrators server role. When I log into the system as
    this new user, I'm able to start the instance but I'm not
    able to stop it. I don't understand this behavior since a
    System administrator has SHUTDOWN privileges. Any
    assistance is greatly appreciated.
                                   Sincerely,
                                            ABG

                              
     

  • Next message: Bill Cheng [MSFT]: "RE: How to create a trusted connection"

    Relevant Pages

    • Re: Domain or Workgroup
      ... What is your current infrastructure setup? ... Administrators or would you be administering the domain? ... How many SQL ... or to remain in their work group and access SQL Server through Server ...
      (microsoft.public.sqlserver.clients)
    • Re: disable local admin rights in sql server
      ... You can remove the builtin\administrators group from SQL ... However, under some scenarios, this can cause ... How to impede Windows NT administrators from ... administering a clustered instance of SQL Server ...
      (microsoft.public.sqlserver.security)
    • Secutiry of db files
      ... unless we create a login for particular one. ... But all administrators are able to stop sql server service and copy ...
      (microsoft.public.sqlserver.programming)
    • Re: Disallow administrator access
      ... You can remove the builtin\administrators group from SQL ... Server but that can sometimes introduce other problems. ... How to impede Windows NT administrators from ... administering a clustered instance of SQL Server ...
      (microsoft.public.sqlserver.security)
    • Security of DB files (mdf,ndf,ldf)
      ... unless we create a login for particular one. ... But all administrators are able to stop sql server service and copy ...
      (microsoft.public.sqlserver.server)