A handy tip for any DBA out there who would like to check if a remote TCP port can be connected to but they don’t have access to telnet.
The catch is that you require a minimum of Windows 8.1, Windows PowerShell 4.0 or Windows Server 2012 R2. Also, notice I didn’t say check a remote UDP port.
You can check your PowerShell version using:
$PSVersionTable.PSVersion
Simply open a PowerShell prompt and using Test-NetConnection specify the destination server and TCP port e.g.
Test-NetConnection -ComputerName SQLServer01 -Port 1433
If that is too long to type, you can use the alias:
TNC -ComputerName SQLServer01 -Port 1433
If you don’t want all that information use:
TNC -ComputerName SQLServer01 -Port 1433 -InformationLevel Quiet
You may receive a Ping TimedOut warning but the TcpTestSucceeded is True, which seems confusing.
This simply means that the ICMP Ping is being blocked. Check with your System Administrator if they would like Ping capability enabled.
This is fantastic for a telnet port test alternative!
Thank you for sharing.