Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

Now that I have your attention with a powerful title how about some context? It is quite common to get this error message when trying to connect to your Azure SQL Database which obviously resides on a “logical” SQL Server.

For this specific example I was trying to connect to the database via Active Directory – Password.  Observe my SSMS (SQL Server Management Studio) window.


Soon as I click connect I would get:


There can be many reasons for this but in my experience it is because of the fact that we are not stating what database to connect to. (I tend to use contained users).

So click the connection properties box and enter your database name in the connect to database section.






10 thoughts on “Azure SQL DB – Login failed for user NT AUTHORITY\ANONYMOUS LOGON.

  1. Pingback: Dew Drop - June 18, 2018 (#2748) - Morning Dew

  2. Pingback: Https azure database ad integrated login failed for anonymous Portal Guide Instructions Help -

  3. Pingback: Https azure sql server ssms login failed Portal Guide Instructions Help -

  4. Pingback: ➤ Iniciar Sesion Failed For User Nt Authority Anonymous Logon Sql Server 【Iniciar Sesion】

  5. Pingback: Azure Sql Server Login Failed For User Create Account -

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 )

Facebook photo

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

Connecting to %s