Re: BUILTIN\Administrators Account!!!!!

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

  • Next message: Sue Hoegemeier: "Re: disable guest account in MSDB" 
    Date: Mon, 02 Aug 2004 18:18:29 -0600

    You can execute the following in Query Analyzer:
    EXEC sp_grantlogin 'BUILTIN\Administrators'

    By default, the group is a member of the sysadmins sql
    server role. If you wanted this back as well, you could
    execute the following:
    EXEC sp_addsrvrolemember 'BUILTIN\Administrators' ,
    'sysadmin'

    -Sue

    On Mon, 2 Aug 2004 10:19:02 -0700, John P
    <JohnP@discussions.microsoft.com> wrote:

    >Hello,
    >
    >I would like to remove sysadmin privleges on the "BUILTIN\Administrators" group on my SQL Server...but before I do - I have a question:
    >
    >If I remove sysadmin privleges and am not happy w/ how this affects my server - is there an easy way to put my system back to the way it was? I'd imagine that if all I did was remove it from sysadmin in EM then all I have to do is grant sysadmin back again. Is this correct?
    >
    >I'd appreciate any feedback...
    >
    >Thanks!
    >
    >John
    >
    >"Satya SKJ" wrote:
    >
    >> We've removed the builtin group from all our production servers without any issues and as referred ensure your login or referred logins has required privileges in order to hand SQL Server.
    >> --
    >> -----------------
    >> Satya SKJ
    >>
    >>
    >>
    >> "Kevin McDonnell [MSFT]" wrote:
    >>
    >> > You'll want to specify another group as SQL system Admins prior to dropping
    >> > this group.
    >> >
    >> > 263712 INF: How to impede Windows NT administrators from administering a
    >> > http://support.microsoft.com/?id=263712
    >> >
    >> > Thanks,
    >> >
    >> > Kevin McDonnell
    >> > Microsoft Corporation
    >> >
    >> > This posting is provided AS IS with no warranties, and confers no rights.
    >> >
    >> >
    >> >
    >> >

  • Next message: Sue Hoegemeier: "Re: disable guest account in MSDB"

    Relevant Pages

    • Re: exec() gives output??
      ... > I'd like to execute a command on the server ... > particular command takes a long time to execute, ... A successful call to exec() replaces the Perl script with whatever execis ...
      (comp.lang.perl.misc)
    • RE: An insert exec statement cannot be nested. Pls HELP.
      ... Before we can use SELECT * FROM OPENQUERY(LOCALSERVER, 'EXEC SP....'), ... Do we put these 3 lines in the stored proc that is running the SELECT ... Or do we just execute the 3 lines manually in query ... server LOCALSERVER? ...
      (microsoft.public.sqlserver.programming)
    • Re: MS03-031 and 818806
      ... I took a looke at the .sql files that were stored as part of the package ... execute sp_addextendedproc 'sp_setuserbylogin','' ... exec sp_MS_marksystemobject 'sp_setuserbylogin' ... > from another SQL2000 server that has not been updated. ...
      (microsoft.public.sqlserver.security)
    • Re: "Linked Table" from a .txt file in SQL Server?
      ... Something similar would be to create a linked server to ... EXEC sp_tables_ex 'TextLinkServer' ... table_name listed when you execute sp_tables_ex which is the ... >on SQL Server. ...
      (microsoft.public.sqlserver.odbc)
    • Re: File Upload - Security Issues
      ... uploaded and the user could upload any or all of these in theory. ... There is no one product that can give you 100% security, ... > Code doesn't execute in local memory space unless remote user has rights ... > You don't have MS Office installed on the server. ...
      (microsoft.public.scripting.vbscript)