Fix for Login Failed for user ‘NT AUTHORITY\Anonymous Logon’ (Microsoft SQL Server,Error:18456).

Received the following error message when trying to login from SSMA to Azure SQL DB “Login failed for user ‘'”

Followed the steps mentioned here to add Azure Active Directory user as an SQL User in a Contained Database user using the following command:


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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.