Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Question Unanswered: SECURITY - sysadmin role

    Hi all,

    Our SQL2000 server now allows all member of the Windows 2000 local administrators group log in with SysAdmin role.

    I only want couple of people with sysadmin role. What should I do
    to prevent that. I was told once that I should delete the
    BUILTIN\Administrator ID and manually add each window login ID
    to SQL server. Am I on the right track?

    Thank you for your help.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    Yes. This is the way to do it (deleting BUILTIN\Administrators).

    Just be sure you do not delete the BUILTIN\Administrators before you add yourself back in individually. If you lose your connection, you could get stuck.

Posting Permissions

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