How to check your server able to connect to SQL server or not ?

Just fast sharing on How to check your server able to connect to SQL server or not ?

Just create one txt file then rename it with Test_SQL.udl (any name with .udl extension ) then you will see the icon :


Double click on it then you will see the windows box at below : fill in the server name and select you window NT account , click on test connection then u will see the database on the drop down box