Error creating new user in SQL Database

Question

I am trying to run the command:

CREATE USER [new_user@mydomain.com] FROM EXTERNAL PROVIDER I get the error message:
Msg 33159, Level 16, State 1, Line 1
Principal 'new_user@mydomain.com' could not be created. Only connections established with Active Directory accounts can create other Active Directory users.

I have tried following the steps laid out here: https://stackoverflow.com/questions/45044760/add-azure-active-directory-user-to-azure-sql-database

But my problem is that I cannot for the life of me figure out how to set myself as the Active Directory admin, because my name is grayed out and it says "Microsoft Account members are not allowed."

I instead tried to set another member of my team as the Active Directory admin, and this works. But this team-member cannot login to the SQL server via Azure Data Studio with his credentials. All that I want to do is to create new users for the SQL database that I created on Azure - this is beyond frustrating and has now eaten up more than 6 hours of my time, and I am a very busy startup CEO. Thanks for any help, Tim

Answer 1

Please configure your Azure AD user as Azure SQL Admin using this step-by-step guide. Somebody in your organization should have administrative privileges to add you as Azure SQL Admin. For more tips on troubleshooting Azure AD authentication issues with Azure SQL Database, please read this troubleshooting guide.