Adding Active Directory User as Sql server users

[MrMob]

Dear
I have Window server 2008 as High end server As domain..
and i have more than 200 users on AD(Active Directory)
And again i have sql server 2005 ...

so what i want is i want to add all the Active Directory user as Sql server Authenticated users. on sql server 2000

Your help will be Very much Appriciated..

Thankyou..

[jonathan184]

I don't think you could do this with AD only accounts if you select windows authentication it will allow your ad users to login when you do this through the security in sql.
I would suggest creating a ad group for the sql users. Drop the users in there then in sql you could control the access and so on.

Sql authenticated is mainly used for local sql accounts but the above will work with your domain if that is what you are looking for.