Test Database Connection

There are different ways to test database connection like SQL management studio or some C# code , but here we will talk about alternative way of testing database connection using UDL file.

Create a empty text file, I have given a name as databaseconnection.txt.

Now change the extension of .txt  to .udl, it will throw an alert and click yes. Now file will be looks like below.

Now open the file.

By passing the all the details over there you can test your data base connection.