Received the following error message when trying to login from SSMA to Azure SQL DB “Login failed for user ‘firstname.lastname@example.org'”
Followed the steps mentioned here to add Azure Active Directory user as an SQL User in a Contained Database user using the following command:
CREATE USER [<Userid>@outlook.com] from EXTERNAL PROVIDER.
After some research on the error, ended up at this article on SSMA with AAD MFA, However since the SSMA version I was using was V18.3.1, I did not have to mentioned Azure AD tenant ID in Options – > Connection Properties. But since I added the user to one of my data bases and not to the master database. I had to change the default data base in options – > Connection Properties and was able to login successfully.
Please do let me know for any other questions while adding Azure Active Directory users to Azure SQL DB/DW.