SummaryHow to test a SQL database connection natively in Windows
Question/Problem DescriptionHow to test a SQL database connection natively in Windows
Resolution1. 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