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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s