471,049 Members | 1,453 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Adding Active Directory User as Sql server users

27
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..
Jul 13 '11 #1
1 2601
jonathan184
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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.