1

Is it possible to restrict access to a SQLServer 2008 database to users of a given AD group, without having to create accounts for each user?

If so, how do I do it?

Users will be authenticating with SQLS with Windows Authentication using their respective accounts.

Thanks

1 Answer 1

3

Sure you can!

Just go to the Security\Logins->New Login... as specify your group in the "Login name" text box: New Login

And them make sure to assing this group to an appropriate database user and role: User mapping

4
  • doesnt this mean i have to authenticate with SQSL as this single login though? Users will be authenticating with their own AD accounts Sep 3, 2010 at 10:33
  • 1
    I don't know what SQSL is and I'm assuming in your question that you mean you want to grant access to a specific database based on AD group membership, and if so, Regent's answer is correct. I've used this method many times. When members of the group access the database with their AD accounts they'll be granted access by virtue of their membership in the group.
    – joeqwerty
    Sep 3, 2010 at 10:49
  • yeah it does work, didnt realise it was this simple. cheers all Sep 3, 2010 at 10:55
  • I meant SQLS (sql server), was a typo Sep 3, 2010 at 10:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .