NT Active Directory Groups and SQL DB Roles

From: GingerDeafMan (gingerdeafmanNOSPAM_at_yahoo.co.uk)
Date: 02/23/05


Date: Wed, 23 Feb 2005 13:15:03 -0000

Is it possible to match SQL DB roles with Active Directory/NT groups?

i.e. A user could be in 2 AD/NT groups (e.g. gAdmin and gUser). I then
want this user to be member of rAdmin and rUser in my database.

I am trying to allow the administration of users in AD/NT, rather than
SQL Server.

Cheers,