If you want to test a connection from a Windows Machine to a SQL server do the following:
-
Create a new text file and be sure that the extension is being shown, i.e. testsql.txt
-
Rename testsql.txt > test.udl (thats UDL)
-
You can then enter all the details for the connection and test.
