Re: BUILTIN\Administrators Login

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/22/04

  • Next message: David Rogers: "RE: Change database Access - (newbie question)" 
    Date: Mon, 22 Mar 2004 14:24:37 -0700

    Whether you get problems or not depends. The following
    article has an 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 Mon, 22 Mar 2004 12:58:47 -0800, "Mike"
    <anonymous@discussions.microsoft.com> wrote:

    >I would like to remove the BUILTIN\Administrators Login
    >from SQL Server 2000 for security purposes.
    >
    >Will there be any problems with SQL Server 2000 running
    >properly if I do this?
    >
    >Thank you.

  • Next message: David Rogers: "RE: Change database Access - (newbie question)"

    Relevant Pages

    • RE: Restricting Access to BUILTINAdministrators
      ... SQL Server Security: Security Admins ... Removing the Builtin Administrators - Some Pitfalls to Avoid ... > and remove access to each of the databases on the server. ...
      (microsoft.public.sqlserver.security)
    • Re: Account to Run SQL under?
      ... you use AD Global Groups to grant the SQL Server DBAs administrative access, ... How to impede Windows NT administrators from administering a clustered ... with great power comes great responsibility. ... If you do not want local administrators to have system admin access rights then all you need to so is restrict the BUILTIN\Administrators rights. ...
      (microsoft.public.sqlserver.server)
    • Re: Lost SA Password
      ... Try logging on as a member of the local Administrators group and ... executing the script with a trusted connection: ... BUILTIN\Administrators SQL Server login. ... > The 'sa' password is not known, and the default database ...
      (microsoft.public.sqlserver.security)
    • OpenDataSource "Unspecified Error" connecting to Excel file
      ... the file is on the local Sql Server. ... Even if I add domain users to the server administrator role, ... administrators group on the Sql Server, ... local administrators group on the Sql Server? ...
      (microsoft.public.sqlserver.connect)
    • OpenDataSource "Unspecified Error" when connecting to local Excel spreadsheet file with no
      ... the file is on the local Sql Server. ... Even if I add domain users to the server administrator role, ... administrators group on the Sql Server, ... local administrators group on the Sql Server? ...
      (microsoft.public.sqlserver.connect)
    • Quantcast