You might have faced issues when you forget your Azure SQL Server password and unable to login in server. Follow the below steps to configure an admin in Azure SQL Server via Azure Portal.
1. Go to Azure SQL Server and navigate to Active Directory admin in you left navigation bar. Then click Set Admin and add your Azure account.
2. Open your SSMS and enter your SQL Server name and in Authentication you can select one of the Active Directory- Password (or Active Directory – Universal with MFA support if MFA is enabled).
iamashishsharma.wordpress.com 