Post reply

Deleting Builtin/Administrators group from sql server

  • June 28, 2004 at 5:20 am

    #162783

    Hi

    Can any one tell me the problems with associate if i delete Builtin/administrators windows group from sql server.

    I need to delete it for my server  and i am going to use  another adminstrator account in the domain.

    what problems can occur .( i need to export all user's and permission but every time it fails if i have windows builtin groups so i need to delete the grop first , i dont see any use of it)  I use  service a/c as  administrator/mcgc  (mcgc domain)  account  to start services now.

     

    deleting above is  not good then i need to know how i can export all users to another new server ?

     

    thanks

     

    bye

  • June 28, 2004 at 9:10 pm

    #512325

    Just make sure you set up some other account with the same permissions as BUILTIN/administrators before deleting it.  It's definitely a recommended best practice though to get rid of this login in SQL Server.

    Derrick Leggett
    Mean Old DBA
    When life gives you a lemon, fire the DBA.

  • June 29, 2004 at 4:46 am

    #512374

    Hi ,

    Do we have any white papers for this ?  My server services are using builtin/administrator  account and another administrator account  ; what ever new domain admin accounts created  is a member of builtin administrator group.

    when i delete the windows security group  under sql  if it is going to remove fro active directory its   a problem.

    if you have done this what's the steps to do this ?

    Thanks

    chami

  • June 29, 2004 at 8:41 am

    #512456

    see this useful article by Brian Kelly. It explains all the steps.

    http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp

    regards

    Peter

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply