Summary
How to test a SQL database connection natively in WindowsQuestion/Problem Description
How to test a SQL database connection natively in WindowsResolution
1. Open Notepad2. 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