Home / server / Questions / 185787
In Process
justSteve
Asked: 2010-09-30 04:14:00 +0800 CST

Map sql's BUILTIN\Administrators to Windows Administrators Group

  • 772

Logged on as 'Administrator' (and a member of just one Group - Administrators) i am seen as God (ok ... god) to the SQL install.

Where do I bestow the same level of permission to all members of the Administrators group?

EDIT: The server's configured to accept Mix Login Mode in case that matters.

thx

windows-server-2008 sql-server permissions

3 Answers

  1. In SQL Server Management Studio, connect to the server you want to manage. Expand Security, then Logins. Right-click on Logins and select New Login.

    Next to the Login name box, click Search...

    Change the Object Types to include Groups. If you're wanting to select Domain Admins (or similar), change the location to your domain, rather than the server.

    Type the Administrators group name into the textbox and click OK.

    On the left side, select the Server Roles page and check the sysadmin role. Finally, click OK.

    • 2

  2. I was able to get around this by creating a new local group called SQLUsers, I added the administrators group to the SQLUsers Group and was able to add this into the SQL server security > logins

    • 1

  3. The workable alternative in my case turns out to be granting the permissions to each of the user accounts that need sql access.

    • 0