Add user defined managed identity to SQL Azure.

  • Hi all,

    So I've got what I'm sure is a very simple syntax issue but I'm struggling to resolve.

    We have created within our Azure SQL server a user assigned managed identity, this was done via the portal and all looks good. The system one is turned off.

    When I connect to the Server using my credentials and try to run the following I get an error

    CREATE USER [name of account] FROM EXTERNAL PROVIDER

    Returns this

    Principal 'name of account' could not be resolved. Error message: ''

    Obviously 'name of account' is the name (taken from the portal).

    Any one any ideas as all I can seem to find online is for system managed ones and they all do the code above.

    Thanks,

    Nic

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Hi,

    So as fate would have it I can answer my own question, the syntax is indeed correct and has now run successfully.

    It seems it took a bit of time for the identity I'm using to be able to be resolved by SQL and by a bit of time I means 12 hours plus but I guess that varies.

    Anyway hope that helps.

    Thanks,

    Nic

  • This was removed by the editor as SPAM

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply