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.
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.
One thought on “Easy way to check the connection to the MS SQL Server”
[…] Before proceeding with the next steps, make sure to test the connection to the SQL Database, using the service user you created earlier. I usually to this using a “UDL” file, as described in the separate post. […]