Post reply

Builtin Administrators group login

  • August 10, 2010 at 5:43 pm

    #238828

    Hi,

    Does SQL Server 2008 won't add Builtin Administrators group login under logins and grant sysadmin rights?

    Please advice

  • August 10, 2010 at 7:42 pm

    #1205105

    That is correct - SQL Server 2008 does not add the BUILTIN\Administrators to SQL Server. This is a security measure to prevent local administrators of the machine from automatically being granted sysadmin rights to SQL Server.

    You should create a DBA AD group, add that group to SQL Server and grant the group admin rights. If there are non DBA's that need sysadmin rights, create another AD group - or add them individually.

    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 1 (of 1 total)

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