Assign active directory security group to server role

Question

Hi Guys,
I'm trying to assign Active Directory Security Group as a member in a server role that i created.
but when i'm open my Object types, i don't have groups option available, only Logins and Server roles.
maybe the solution is to create login that is base on active directory security group, but i tried to find how to do it and failed.
Anyone have a solution?
Thanks

Answer 1

Hi @bababalush ,

> maybe the solution is to create login that is base on active directory security group, but i tried to find how to do it and failed.

You can create SQL login for AD group as below screenshot from SSMS UI. Right click Logins > New login

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

CREATE LOGIN [DOMAIN\GROUP] FROM WINDOWS
ALTER SERVER ROLE MyServerRole ADD MEMBER [DOMAIN\GROUP]