Showing posts with label Domain Group. Show all posts
Showing posts with label Domain Group. Show all posts

Thursday, January 12, 2012

Add a domain group to SQL Server Logins

You may notice that by default you can add domain user accounts but not security groups to SQL Server logins.
To grant permission to a group, navigate from the Management Studio to Security -> Logins, right click -> "New Login", click Search button next to "Login name:", click "Object Types", check "Groups". Now you should be able to resolve group names as well