Adding AD group perms to SQL Server

Why doesn’t SQL Server automatically check for the Group –> Object type when you are adding perms via SSMS? This hangs me up almost every time. I think “omg where is the group, why isn’t it there?” and then I remember, oh yeah, I gotta check that box. It seems like it should be checked by default. Does anyone else know why Groups isn’t checked by default?

Anyway, reminder to myself, make sure the Groups object type is selected when adding a group through the GUI.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.