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.



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.

| improve this answer | |
  • Tried that and get: Create failed for Login 'machName\Administrators'. - not found. I used the 'Advanced | Find' to be sure i didn't typo the spelling - and clicked 'Check Names'. Same non-joy. thx – justSteve Sep 29 '10 at 13:11
  • Did you remember to change Object Types to include groups? – Ben Wyatt Sep 29 '10 at 13:44
  • Right...that'd be the only way to see 'Administrators' and thus run the 'Check Names'. – justSteve Sep 29 '10 at 14:25
  • 2
    I believe I know what's going on here. You just need to add BUILTIN\Administrators to the sysadmin role. According to this KB article, that is the MACHINE\Administrators group. support.microsoft.com/kb/216808 – Ben Wyatt Sep 29 '10 at 15:11
  • If that doesn't get the job done, try mapping BUILTIN\Administrators do a login that is in db_owner on each database as well. You can do that under User Mapping in the login properties window. – Ben Wyatt Sep 29 '10 at 15:14

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

| improve this answer | |

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

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.