Checking connectivity using PortQueryUI

Have you tried PortQuery? A command line tool for checking if a given port of a computer / server is open or shall we say “Listening”.  Some of PortQuery links are found over here: and also on TechNet and if you look closely there are some samples also here:

But that’s not entirely what this blog post is all about 😀 I was using PortQuery in a number of instance now and to my amazement, there is this little tool called PortQueryUI, Yes folks PortQuery with UI and not run from the CMD!. (And it runs without problems with my Windows7 workstation).

Just download and Unzip.

In this instance I need to use PortQueryUI to check if there is an existing SQL Instance in a remote server and Yes, the remote server indeed has an instance of SQL. It was indicated at the bottom TCP port 1433 (ms-sql-s service): LISTENING.

I tried this is on my localmachine ( I did not installed any SQL Instance on my machine and upon checking, PortQuery reported NOT LISTENING. There is one more response that PortQuery is throwing, Filtered. For clarity I’ve copy pasted these from the KB article:

  • Listening
    A process is listening on the port on the computer that you selected. Portqry.exe received a response from the port.
  • Not Listening
    No process is listening on the target port on the target system. Portqry.exe received an Internet Control Message Protocol (ICMP) "Destination Unreachable – Port Unreachable" message back from the target UDP port. Or if the target port is a TCP port, Portqry received a TCP acknowledgement packet with the Reset flag set.
  • Filtered
    The port on the computer that you selected is being filtered. Portqry.exe did not receive a response from the port. A process may or may not be listening on the port. By default, TCP ports are queried three times, and UDP ports are queried one time before a report indicates that the port is filtered.

    I’m really glad that old tools still run without problems with Windows7 🙂 So do check this out and to get the PortQryUI – User Interface for the PortQry Command Line Port Scanner from Microsoft Downloads:


    Byaheng Langit – The Visual Studio 2010 Community Launch!

    Have you attended the “Byaheng Langit” last Saturday, May 15, 2010: 

    The Microsoft Communities is inviting you to the community launch of Visual Studio 2010! Get the chance to learn some of the new features of Visual Studio 2010 and also meet the Microsoft MVPs in one afternoon full of technology learning, and camaraderie from people that shares your same interest. Likewise, get a chance to participate in a discussion with MVPs that will surely rock the house.


    Now time to demo on Microsoft Patterns and Practices – Web Service Software Factory Modeling Edition on Visual Studio 2010. My first ever Dev topic that I delivered. Hope I can do more of this stuffs 🙂 (I’m still a dev by trade :P)

    In this event, get to meet and greet fellow Microsoft technology enthusiasts as well the Microsoft Most Valuable Professionals (MVPs) in one afternoon of technology discussions, and some great things in the Microsoft developer space. Get to know some of Visual Studio 2010 features and related .NET 4.0 topics that will surely ignite your interest getting your hands dirty with the latest Microsoft developer tools.
    Topics include:

    * SharePoint 2010 Programming with Visual Studio 2010
    * Web Development with Visual Studio 2010 and Telerik Web Controls
    * Runtime Object Composition with C# 4.0 dynamics
    * Service Factory on Visual Studio 2010 (Web Service Software Factory 2010 RC)

    Also, we have a roundtable discussion on T-SQL with the Microsoft MVPs where everyone can engage and exchange ideas and thoughts.

    I’ll be uploading more pictures and tagging people in my Facebook album:

    Many thanks also to MVP Patrick Oliveros and the rest of the Philippine .Net Users Group (PHINUG) and Philippine SQL Server Users Group for inviting us 🙂