2

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.

3

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.

2

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.