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.

AD FAILED

Soon as I click connect I would get:

analogin

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.

needto

The result that you want.

ImIn

 

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

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

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 )

w

Connecting to %s