468,738 Members | 1,750 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,738 developers. It's quick & easy.

Adding Active Directory User as Sql server users

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..

Jul 13 '11 #1
1 2570
154 100+
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.
Jan 3 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Mario Rodriguez | last post: by
reply views Thread by Kooki | last post: by
reply views Thread by Kooki | last post: by
7 posts views Thread by Vio | last post: by
4 posts views Thread by Spam Catcher | last post: by
1 post views Thread by CARIGAR | last post: by
2 posts views Thread by xarzu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.