Testing connection to server and port
Posted by Sinclair Hughes, Last modified by Sinclair Hughes on 06 March 2019 01:33 PM

You can use Powershell command to check that you are able to get a connection to a server and a port.  Telnet can also be used but the Telnet Client is no longer installed by default.

This test is useful to determine whether a workstation is able to connect to a remote SQL Server and Port.  It can't test the port if you are using the SQL Browser application to browse Dynamic ports.

1. Start Powershell
2. Enter the following command:
           Test-NetConnection <URL, IP or server name> -port <port>
    e.g. Test-NetConnection  172.27.196.24  -port 1433