I am trying to connect to an Azure SQL database via SSMS. The connection string supplied by Azure is:

Server=tcp:SERVER_NAME.database.windows.net,1433;Initial Catalog=DATABASE_NAME;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

So, first of all I’m not sure if I should include ALL of

tcp:SERVER_NAME.database.windows.net,1433 

in the server name when connecting via SSMS. Also, the username is an email address. Let’s say it’s:

foo@bar.com 

So, this is what I tried:

ServerName: SERVER_NAME.database.windows.net Login:      foo@bar.com@SERVER_NAME.database.windows.net Password:   [password] 

At first when I tried, I was told that the IP was not allowed. So I added the IP to the server firewall settings. But now, I get this:

Login failed for user foo@bar.com

I am using the same UserID and Password that I use to log into the Azure portal. And it’s the UserID that is specified in the Access Control window.

I am working from home, but I have also tried while on my company’s VPN. Neither work.

Is there something else I’m doing wrong?