Try this:
CREATE USER [testgroup] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA=[dbo]
Make sure users specify the database name when getting connected to the database.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello.
I have a Azure AD Group called "testgroup@X .at"
Issuing:
CREATE LOGIN [testgroup@X .at] FROM EXTERNAL PROVIDER;
throws an error:
Msg 33130, Level 16, State 1, Line 23
Principal 'testgroup@X .at' could not be found or this principal type is not supported.
CREATE LOGIN [testuser@X .at] FROM EXTERNAL PROVIDER;
works though.
This is also not working:
CREATE LOGIN [testgroup_XXX.at#EXT#@X .onmicrosoft.com] FROM EXTERNAL PROVIDER
I want to have a LOGIN/USER for all the members of the group.
Any idea why it's not working?
Try this:
CREATE USER [testgroup] FROM EXTERNAL PROVIDER WITH DEFAULT_SCHEMA=[dbo]
Make sure users specify the database name when getting connected to the database.