How to test an SQL Server connection

  1. Create a new empty text document (.txt) on your pc. (e.g.: on your desktop)
  2. Rename it to X.UDL
  3. Double click the file to open the Data Link Properties
  4. Select the correct provider on the [Provider] tabpage
    Fill in your connection details on the [Connection] tabpage
  5. Click [OK] to close the Data Link Properties window when you have a succesful connection (via [Test Connection])
  6. Now open the X.UDL with your favorite text editor (e.g.: notepad, notepad++)
    You should see your connection string now!

;-)