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;
xxxxxxx.database.windows.net,1433"xxxxxxx" represents the server name
zzzzz@xxxxxxx"zzzzz" represents your username, and "xxxxxxx" the server name
aaaaaarepresents your real password