Test SQL Connection in Azure

Leave a comment

November 14, 2016 by Ruaan Harmzen

Azure VMs and connectivity brings some interesting challenges to the fore. I have a scenario where I created 4 new VMs (3 x app and 1 x sql). The App servers are bare bone so did not have any SQL client tools. I found the method below the easiest way to test connectivity to the SQL Server:

  • On the app server create a new text file and change the extension to .UDL
  • Double click and it will open a SQL Connection window
  • Enter your details and test

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: