Use connection string to connect to Azure database from SSMS? I have a connection string for an Azure database. I'm hoping there is a place in SSMS where I can plop in that string and connect to it. Alternatively, if there is a way to do it with a T-SQL query, that would be even better.
Given the connection string:

Data Source=tcp:xxxxxxx.database.windows.net,1433;Initial Catalog=DatabaseName;User ID=zzzzz@xxxxxxx;Password=aaaaaa;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;Application Name=YourAppName;





Server name: xxxxxxx.database.windows.net,1433 "xxxxxxx" represents the server name
Login: zzzzz@xxxxxxx "zzzzz" represents your username, and "xxxxxxx" the server name
Password: aaaaaa represents your real password




As Pedro mentioned you will only be able to connect to an Azure database if your IP is white listed. The Microsoft has a step by step write up on how to do this in their new portal.