Test SQL Connection in Azure

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

Your email address will not be published. Required fields are marked *