create user for external provider error

Hector 61 Reputation points


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.
521 questions
Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 27,391 Reputation points MVP

    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.


    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

    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 ?