Cannot Connect To Your Azure SQL DB Logical Server - Azure SQL Server

Recently I setup Azure SQL Server from Azure portal UI and I wanted to access it from outside so I configured all required steps so that it is accessible remotely like following screen,

 

 

 

but still I was getting following error while trying to connect to Azure SQL Server from my machine,

 

Cannot connect to your Azure SQL DB logical server/Azure SQL MI server, exception: Cannot open server “…..” requested by the login. The login failed.”

 

While troubleshooting this issues, luckily I found this post.

Based on this post if you are getting this error, you can suffix @YourSQLServerName in your user name.

For example suppose I am trying to access my devssisdbserver.database.windows.net using following User: [email protected] and getting above error.

 

So to resolve this issue I have to suffix my sqlserver name after the user name, so I tried using [email protected]@devssisdbserver and it worked !

 

Hope it will help someone !!