Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Builtin\Administrator login

    Hi All,

    I have few questions about above mentioned login.

    1. What is this login for?

    2. Can I delete it without causing any problems? I don't want the network guys have the sysadmin role to the SQL Server.

    Can you tell me what I need to do? Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    This is the login that is used by administrators on the local machine. It is handy in case you forget the sa password, and need to change it. In order to disable it, set up a DBA group, and add it to the sysadmin server role before doing anything else. Then you can safely drop the builtin administrators group. If you drop your DBA group from the domain after that, then all of your SQL Servers are auto-magically transmogrified into glorified server room space heaters.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    If you drop your DBA group from the domain after that, then all of your SQL Servers are auto-magically transmogrified into glorified server room space heaters.
    LOL

    Do you speak from experience? Or is this...ahem...second-hand knowledge?

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •