Assign active directory security group to server role

bababalush 21 Reputation points
2021-03-07T15:50:45.357+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,353 questions
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,238 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2021-03-08T06:06:00.887+00:00

    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

    75265-screenshot-2021-03-08-135652.jpg

    75234-screenshot-2021-03-08-140025.jpg

    75281-screenshot-2021-03-08-140145.jpg


    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.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Erland Sommarskog 107.1K Reputation points
    2021-03-07T16:17:36.71+00:00
    CREATE LOGIN [DOMAIN\GROUP] FROM WINDOWS
    ALTER SERVER ROLE MyServerRole ADD MEMBER [DOMAIN\GROUP]
    
    0 comments No comments