patternMinor
Use connection string to connect to Azure database from SSMS?
Viewed 0 times
fromconnectssmsdatabaseazureusestringconnection
Problem
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.
Solution
Given the connection string:
-
Server name:
-
Login:
-
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.
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 passwordAs 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.
Code Snippets
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;Context
StackExchange Database Administrators Q#129719, answer score: 7
Revisions (0)
No revisions yet.