Unable to log into Azure SQL database in Azure Portal using AAD Global Admin (member type) account

I am Global Administrator of the Azure subscription I own.

Steps:

• I logged into Azure Portal using my credentials.
• I created an Azure SQL database (including initiating a new Azure SQL Server instance).
• I set the database security to permit both SQL Login and AAD Auth.
• I set my AAD account to be SQL Admin of the server.

In the poral, when I navigate to the ‘Query editor (preview)’ page for the created database, the option to login via Azure Directory Authentication, displays the following error for my account:

    *Login failed for user '<token-identified principal>'.*

What could the issue be / how can I resolve?

Thank you

Answer

Solved:

I created a Group (called is SQLAdmin) in Azure Active Directory; and added my account to this.

I set the SQL Server Admin in the SQL server’s SettingsActive Directory page to the SQLAdmin group.

When navigated back to the Query editor (preview) page for the database, the error no longer appeared; and selecting the ‘Continue as ….’ button provided me access to the SQL Query window