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.
The result that you want.