0

I am able to add individual AD logins as a login in azure sql managed instance, when i try to add a DL is the same way i am getting the following error.

error: Principal '' could not be found or this principal type is not supported.

Query user: CREATE LOGIN [] FROM EXTERNAL PROVIDER GO

Want to add a DL as login so that all individuals withing the DL can access the instance, isn't this not possible? What am I doing wrong here?

1

To create a DL (assuming it is a group in AAD), you need to create without the @domain.. on the database that you want to connect.. example:

CREATE USER [GroupName] FROM EXTERNAL PROVIDER

Here you have a link

https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-23-how-to-add-aad-security-groups-to-azure-sql/ba-p/368866

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.