Add user defined managed identity to SQL Azure.

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  February 15, 2022 at 9:10 am

  Go to Answer

  #3983763

  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

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  February 16, 2022 at 10:10 am

  #3984262

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

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

• NicHopper

  SSCrazy Eights

  Points: 9090

  More actions

  February 17, 2022 at 1:26 pm

  Answer

  #3984893

  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

  Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

• July 26, 2022 at 6:57 am

  This was removed by the editor as SPAM