Removing the BUILTIN/Administrators login in SQL Server

  • I need to remove BUILTIN/Administrators login in SQL Server 2000 standard. But when I remove it, I am unable to start the services. I know if I create an account with sys privs and grant them access to start the services it will work. Is it at all possible to start the services without creating an account to give it sys privs and remove the BUILTIN/Administrators login in SQL Server

    thx

  • No, if you are going to remove (or disable, which I prefer) the BUILTIN\Administrators group you need to provide the user(s) running the services privileges in SQL Server.

    In SQL Server 2005 and above, there are local groups created that manage this - but, since you are on SQL Server 2000 you need to do this yourself.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 2 (of 2 total)

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