create user for external provider error

Hector 61 Reputation points
2021-02-14T19:19:18.997+00:00

Hi

When tried to create scem-d-awp-tev-001 user from external provider on the database

we are receiving

Msg 33131, Level 16, State 1, Line 1
Principal 'scem-d-awp-tev-001' has a duplicate display name. Make the display name unique in Azure Active Directory and execute this statement again.

Webapp name:scem-d-awp-tev-001
Identity name: scem-d-awp-tev-001

Microsoft Identity Manager
Microsoft Identity Manager
A family of Microsoft products that manage a user's digital identity using identity synchronization, certificate management, and user provisioning.
716 questions
Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 32,831 Reputation points MVP
    2021-02-15T03:10:33.86+00:00

    Hey @Hector ,
    In Azure AD, you can create service principals with same name but different application Ids.
    So please search in AAD, by that name and confirm whether there are 2 Apps with the same name.

    You would have to delete one of the App and recreate it with new name.

    67952-aad.png

    In case if you cannot delete the sp , create a cloud group in AAD and add the needed sp in that dl and create user of that DL in database.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Hector 61 Reputation points
    2021-02-15T15:35:37.673+00:00

    Hi , Thank you for you response,

    In this case yes, we have 2 SP with the same name, a webapp scem-d-awp-tev-001 and after we enable identity option for the web app a new SP was created with the same name and different id. In this case can we change the identity name ?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.