One nice gem from Steve Rachui’s blog is a trick on how to simply troubleshoot remote SQL connections.
Just create an empty txt file anywhere on the disk and give it an UDL extension and click it. You will see a tool popping up with several tabs. on the first tab you will find SQL for instance, but also other types of data connections. On the second tab you can enter info like server name and database name and authentication needs.
Nice! Very very nice!
Bob Cornelissen
