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
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.