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).
- Create a new file with extension .udl (e.g. TestConnection.udl)
- Open the newly created file:
3. Fill in the data
– Choose Provider
– Fill the connection settings and click “Test Connection”