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 ‘live.com#@outlook.com'”

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.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.