RE: BUILTIN\Administrators Account!!!!!

From: John P (JohnP_at_discussions.microsoft.com)
Date: 08/02/04

  • Next message: Raoul Laoyan: "RE: SQLServer Agent problems with windows security -- Help desperately" 
    Date: Mon, 2 Aug 2004 10:19:02 -0700

    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: Raoul Laoyan: "RE: SQLServer Agent problems with windows security -- Help desperately"