Here is a tip I shared yesterday with a customer.
If you need to create a connection string and don't remember the syntax, here is a simple way of achieving your goal.
- In a file folder or your Windows desktop, create a text file and rename it myCN.udl (only .udl extension is important)
- double click the file
- Enter the parameters in the UI
- Close the UI
- Open myCN.udl with notepad: you get your connection string