Updated by Jake Malmad on Mar 20, 2015
A common troubleshooting step in database backed applications is making certain that communication is possible from the web or application server directly to the database. This article outlines a fast and easy way to verify connectivity from a Windows Server to a Microsoft SQL database.
Create a new text folder on the server by right click-> New -> "New Text Document". You may want to name it similar to the database to be tested, in this instance it is simply called "test.txt"
Change the file extension to .udl. You may need to enable "Show File Extensions" in the view pane
Rename the file extension to ".UDL"
Open the file, and you will be greated with a connection dialog.
You can now enter the appropriate database hostname, credentials, and even choose the desired database from the drop down menu:
Simply select "Test Connection" and you will be informed if the connection is successful or fails.