Test a database connection

  1. Create a file called [SOMETHING].udl
  2. Double click to run it
  3. Enter connection details in the dialog
  4. Click ‘Test Connection’

The go here: http://support.microsoft.com/kb/328306