Cannot able create user on Azure Synapsis (Datawhare house database) with AAD service principle

Ramprasath R 1

Cannot able create user on Azure Synapsis (Datawhare house database) with AAD service principle.

Error:
Msg 33134, Level 16, State 1, Line 1
Principal 'XXX' could not be resolved. Error message: ''

1 answer

Alberto Morillo 32,891 Reputation points MVP

2022-04-26T20:29:24.017+00:00

Please, follow these steps to enable service principals to create Azure AD users.
Please sign in to rate this answer.

1 person found this answer helpful.
Oury Ba-MSFT 16,471 Reputation points Microsoft Employee

2022-04-26T23:33:00.847+00:00

@Anonymous Please do not forget to mark as accept answer if the steps shared by @Alberto Morillo helped.

Regards,
Oury

Ramprasath R 1 Reputation point

2022-04-27T17:19:49.013+00:00

I tried but did not work still the same error. I'm trying to create user from AAD security group and it has reader permission on portal. I'm doing it on Azrue SQL data ware house database.

Syntax:

CREATE USER [Security Group name] FROM EXTERNAL PROVIDER

Error:
Msg 33134, Level 16, State 1, Line 1
Principal 'XXX' could not be resolved. Error message: ''

Oury Ba-MSFT 16,471 Reputation points Microsoft Employee

2022-05-23T22:15:45.8+00:00

Hi @Anonymous

Azure AD users and service principals (Azure AD applications) that are members of more than 2048 Azure AD security groups aren't supported to login into the database in SQL Database, Managed Instance, or Azure Synapse.

DisplayName of Azure AD object for Azure AD Groups and Azure AD Applications. If you had the Nurses security group, you would use:

CREATE USER [Nurses] FROM EXTERNAL PROVIDER.

Regards,
Oury
Sign in to comment