Have you ever been troubleshooting a problem with remote SQL Iproxy MP, remote DB, etc) and wanted to test to see if the local system account (or any account for that matter) could make a remote connection to SQL but you didn't want to install the SQL tools just to make that test? Seems there is a file type -- UDL file -- that you can simply create that bring up a window to allow testing of remote connections to SQL.
Microsoft's own Steve Rachui explains how to quickly and easily test remote SQL connectivity using any account you like:
"Just go anywhere on your system and create an empty text file named anything but instead of txt make sure the extension is UDL. Then, double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections.
Very easy to use to test connectivity with a known user account or as local system (using PSExec)."