If you need to test connectivity from your workstation to a remote database server, here is a handy trick which will help you accomplish it.
Right-click on a blank area of your windows desktop and choose create new text file:
Create and save the file name with something like TestConn.udl
Notice the file extension is UDL which stands for Universal Data Link.
Double-click the file shortcut to launch the UDL applet and choose the data provider connectivity you wish to test:
Click Next, then type server name, authentication, database and click Test Connection:
1. If Test Connection succeeds, a confirmation message displays:
2. After test connection succeeds, click ok...