Can't connect to Azure SQL database from Visual Studio

Question

When I try to open my Azure SQL Server database in Visual Studio

and then use my Azure user account (I already added this user to SQL Owner role) [email protected] I got the following error

Cannot open server "DomainName.com" requested by the login. The login failed. (Microsoft SQL Server, Error: 40532)

Answer 1

It seems to be I need to use [email protected]@AzureSQLInstanceName as a user name, and my domain password as password. I got that from the database connection strings section on Azure portal.

Answer 2

Make sure you've added the IP address you are calling from the to SQL Firewall: Your Server >> Settings >> Firewall Settings.