ListManager | How to test a SQL database connection natively in Windows

Summary

How to test a SQL database connection natively in Windows

Question/Problem Description

How to test a SQL database connection natively in Windows

Resolution

1. Open Notepad
2. Create a blank file and save it as Test.udl remembering to set save as type to "All Files"

3. Run the Test.udl file

4. On the provider tab select your provider (Microsoft OLE DB Provider for SQL Server or SQL Server Native Client X depending on what is used)

5. On the Connection tab enter your Server name, User name, Password and Database name

6. Click Test Connection