SQL Data Link Properties shortcut

If you want to test a connection from a Windows Machine to a SQL server do the following:

  1. Create a new text file and be sure that the extension is being shown, i.e. testsql.txt

  2. Rename testsql.txt > test.udl (thats UDL)

  3. You can then enter all the details for the connection and test.