Quickly check a connection to DB Server (Windows)

One way of a quick connection test to a certain Database server can be done by creating a udl file (Microsoft Universal Data Link File).

1. Create a new file with extension .udl (e.g. TestConnection.udl)
2. Open the newly created file:

3. Fill in the data
– Choose Provider
– Fill the connection settings and click “Test Connection”