How to add Active Directory user group as login in SQL Server

by

In SQL Server Management Studio, go to Object Explorer > (your server) > Security > Logins and right-click New Login:

enter image description here

Then in the dialog box that pops up, pick the types of objects you want to see (Groups is disabled by default – check it!) and pick the location where you want to look for your objects (e.g. use Entire Directory) and then find your AD group.

enter image description here

You now have a regular SQL Server Login – just like when you create one for a single AD user. Give that new login the permissions on the databases it needs, and off you go!

Any member of that AD group can now login to SQL Server and use your database.

More Related Contents:

  1. An attempt to login using SQL authentication failed
  2. Removing the remembered login and password list in SQL Server Management Studio
  3. Using merge..output to get mapping between source.id and target.id
  4. SQL Server, How to set auto increment after creating a table without data loss?
  5. How can I truncate a datetime in SQL Server?
  6. Errors: “INSERT EXEC statement cannot be nested.” and “Cannot use the ROLLBACK statement within an INSERT-EXEC statement.” How to solve this?
  7. Import Excel spreadsheet columns into SQL Server database
  8. SqlServer: Login failed for user
  9. SQL Server 2008 Empty String vs. Space
  10. How to set a default value for an existing column
  11. How to drop column with constraint?
  12. SQL Server: combining multiple rows into one row
  13. SQL Server Query: Fast with Literal but Slow with Variable
  14. How do I find a stored procedure containing ?
  15. SQL Server GUID sort algorithm. Why?
  16. Access is denied when attaching a database
  17. SQL Server, the misleading XLOCK & optimizations
  18. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  19. How to find SQL Server running port?
  20. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  21. Changing SQL Server collation to case insensitive from case sensitive?
  22. Unable to login to SQL Server + SQL Server Authentication + Error: 18456
  23. What’s the best way to store co-ordinates (longitude/latitude, from Google Maps) in SQL Server?
  24. Database design: Calculating the Account Balance
  25. INFORMATION_SCHEMA vs sysobjects
  26. Merge multiple rows into a single row
  27. How to wait for 2 seconds?
  28. SQL Server 2008 can’t login with newly created user
  29. Find broken objects in SQL Server
  30. Populate Dataset With Table Names From Stored Procedure

Leave a Comment