I would like to import all users from Active Directory into Security/Users.

What I do is the following:

  • Go to Security -> Users
  • Right click Users -> New User...
  • User type: Windows user, click on '...' at User Name
  • Define object type to User and location to my Active Directory one
  • Click on Find Now

Now I can see all users in this specific domain. What I cannot do is select more than one user from this list (e.g. by holding shift). So basically I would have to do it user by user. Since there are many users that would take a long time. And I am also wondering that there should be a 'smarter' way to do it.

Am I missing something? Am I doing something wrong?

Thanks for the help!


Am I missing something? Am I doing something wrong?

It's unusual to add a large number of individual active directory logins to a SQL Server. Instead add logins for Active Directory Groups to take care of most of your users.

See, eg: https://stackoverflow.com/questions/5029014/how-to-add-active-directory-user-group-as-login-in-sql-server

  • I've tried that before. I still have to specify the username (or 'Enter the object name to select:'). I cannot just select Active Directory Group as a whole (if I press OK,nothing happens). – bmorvaj Nov 23 '18 at 10:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.