Re: disable local admin rights in sql server

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

  • Next message: Kevin McDonnell [MSFT]: "Re: Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed" 
    Date: Thu, 18 Nov 2004 17:01:20 -0700

    You can remove the builtin\administrators group from SQL
    Server. However, under some scenarios, this can cause
    problems. Whether you get problems or not depends. The
    following article has a more information section with links
    to some issues that could come up:
    INF: How to impede Windows NT administrators from
    administering a clustered instance of SQL Server
    http://support.microsoft.com/?id=263712

    -Sue

    On Thu, 18 Nov 2004 14:49:06 -0800, "culam"
    <culam@discussions.microsoft.com> wrote:

    >Can I disable local admin right in SQL Server?
    >What is the affect if I could do that?
    >
    >Your response would be greatly appreaciated,
    >Culam

  • Next message: Kevin McDonnell [MSFT]: "Re: Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed"

    Relevant Pages

    • New Sysadmin cannot stop SQL instance...
      ... I'm running SQL Server 2000 on Windows 2000 ... I created a new Windows user who is not ... I entered into the SQL ... Administrators server role. ...
      (microsoft.public.sqlserver.security)
    • 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)
    • 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)
    • 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)