Use connection string to connect to Azure database from SSMS?

Question

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.

Answer 1

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;

Connection screen shot

• 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.

• Mladen B.: Where do you enter DatabaseName from the connection string?

Answer 2

Additionaly to the previous answer you must open your IP on Azure SQL .. enter image description here