Easy way to check the connection to the MS SQL Server

After the installation of Microsoft SQL Server, to make sure that the instance can be accessed by the other software, like IBM Traveler, a simple “UDL Test” can be done. This is very useful in Windows environments, due to the fact that you do not need to install any extra software like IBM Data Studio or MS Management Studio.

Just create a new file with “.udl” extension. After that, just open the file by double-clicking it.

2018-01-17 21_29_30-Data Link Properties

After that you can enter the server and instance name, or just select it. Then you can test the credentials you intend to use for the application. You can even specify the Database you want to connect to.

There are many more settings to choose, but for a simple test I never needed anything else than described above.


Deleting Port numbers from LotusConnections-config.xml File

Short after installing Connections I always delete the port numbers or change the URL completely in the “LotusConnections-config.xml” file so that Connections Applications could be accessed without typing the port numbers as a part of an URL.

Doing this manually can consume lot of time.

You can automate this process by using the replace function in “Notepad ++” or “UltraEdit” editors as described in following.

Notepad ++




I hope this helps. 🙂