HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Use connection string to connect to Azure database from SSMS?

Submitted by: @import:stackexchange-dba··
0
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:

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.

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.