How to test SQL database connection in simple steps

I saw many questions regarding how to check connection string in asp.net, i hope below steps will help programmers to check database connectivity.

1. Open a notepad file and save the file with the extension "test.udl".
2. DOuble click test.udl to open DataLink properties.
3. From the provider tab select the OLEDB provider for SQL database.
4. From the connection tab select/Type the servername and Provide User id and password if you have and select the database you want to use.
5. Click on test connection to test the connectivity and click OK
6. Right click test.udl and open it in notepad.

You can copy the connection string from here....

You can use this technique for any database.