Microsoft SQL Server v13 bulk add users from active directory
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