Ever find yourself needing to test connectivity, but you’re on a machine with no client tools? It happens to me occasionally. Here’s one trick to help:
Right-click on the Windows Desktop, hover over New, and click Text Document:
Rename the file to test.udl:
Because you are changing the extension, you will be prompted:
Click Yes. Double-click the test.udl file to open the Data Link Properties window. Enter (or select) the server name, select integrated security or SQL Login and provide credentials, then select or enter a database name:
Click the Test Connection button to test connectivity:
There you have it – a way to test connectivity without database client tools installed!