Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to have windows authentication login to SQL 2008, the problem I'm facing is that I want to have a User group to be a login, which i succeed in setting up a Login for the SQL database and a user for the database. But when I login with windows authentication it fails.

Example: I added a Login with windows authentication MyDomain\SqlUsers

MyDomain\Robert is in the MyDomain\SqlUsers User Group.

I login in(while logged in as MyDomain\Robert) to Sql managementstudio and it fails.

What am I doing wrong?

share|improve this question
More details on the error would potentially help in solving the problem quicker. – BinaryMisfit Jul 14 '09 at 8:01
up vote 1 down vote accepted

After you create the login you need to add the login to the databases.

What's the error message you get when logging in with MyDomain\Robert?

share|improve this answer

Did you set, in the Status tab of the Login properties, the 'Grant Permission' checkbox?

share|improve this answer

In the Login Properties there's a section titled "User mapping". You need to use this to grant your group access to the database(s) and specify what access they have.

Using a Windows group does work as I use this myself (along with millions of other SQL dbas :-)


share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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