How to Test a SQL Server Connection

The fastest and easiest way I’ve learned to test if I have a SQL Server connection configured property is to use a Universal Data Link (UDL) file.  Not only can the connectivity be confirmed, the tested connections string can be extracted by opening the UDL in a text editor and copied to an application; no more mistyping a connection string!  Here’s a quick demo of how to use it.