How check SQL Connection is Success?

How check SQL Connection is Success?
You can easily check your connection is success or not by using following steps. In here you do not want to run the SQL Management Studio for that.

1st step:
Open a note pad.
Start ->Run ->cmd -> type (notepad)

2nd step:
When notepad opens you must save it using any name with the udl extension. You can save it.
File ->Save As
Ex. Sqlconn.udl






Now you can see some icon with Sqlcon.udl is created on your folder which you save in previous step.

3rd step:
Next you must open that one, simply by clicking on it. Figure 1 show that when you opened your Sqlconn.udl.



















Figure 1 shows that, when opened the Sqlconn.udl which you created on previous steps.

Select your prefer connection from that. In here you must select, “Microsoft OLE DB Provider for SQL Server”. And go to Next>>

4th step:
By providing your Server name, User name, Password and database you can test connection. If connection is success it provide Connection success message otherwise provide Connection not success message. Figure 2 is connection.



















Figure 2 shows that how to provide connection details and check connection is success.

5th step:
Go to Sqlconn.udl and right click and give open with notepad. When it opens with notepad you can see the connection string. It will generate connection string.

Your Comments are highly appreciated; it will be improving my knowledge also.