Guest User | Sign In

Frequently Asked Questions

Using the Microsoft Port Query Utility to test connectivity of wireless sensors/gateway hub to database


NETWORK TEST TOOL

Use the port query utility.

Learn how to use the Microsoft Port Query to test whether you can connect from a Workstation (or Ethernet Wall Port) to the People Counter database server.

Check Communication to Database Server using Microsoft Port Query

Microsoft Port Query is an easy-to-use tool that enables you to test whether you can connect from a Workstation (or Ethernet Wall Port) to the database server, and whether the RDBMS is listening for connection requests.

image
  • Launch the Microsoft Port Query program, which will be located:

C:\Downloads\PortQryUI\portqueryui.exe

image

Note: Replace C:\Downloads with the actual path where the applications have been installed.


image



  1. Enter the Destination IP address of the database server used when installing IMMOTION
  2. Select the Manually input query ports option.
  3. Enter the Ports to query:

    • Default IMMOTION Port is, enter: 55555
  4. Protocol: TCP
  5. Then click the Query button to start the search


Query Results



  • If the Query result is LISTENING then this indicates:

    • the Workstation (or Ethernet Wall Port) can communicate to the database server OK
    image



  • If the Query result is NOT LISTENING then this indicates:

    • the Workstation (or Ethernet Wall Port) is unable to communicate to the RDBMS on the database server

      You should refer this problem to your organisation’s database or network administrator to follow up.
    • Possible reasons why it is unable to communicate to the RDBMS on the database server:

      • the database server is not running.
      • the database server is disconnected from the network.
      • the workstation (or Ethernet Wall Port) is disconnected from the network.
      • there is a problem with the network (for example: switch is faulty, DHCP is not running, etc.) or network configuration.
      • the RDBMS is not running on the database server (check in Windows Services whether the RDBMS (Microsoft SQL Server or Oracle) is running
      • the enterprise firewall is preventing connectivity via this Port.
      • the workstation firewall (for example: Windows firewall) is preventing connectivity via this Port.

  • If the Query result is FILTERED
    then this indicates:
    • the enterprise firewall is preventing connectivity via this Port
    • the workstation firewall (for example: Windows firewall) is preventing connectivity via this Port
      You should refer this problem to your organisation’s database or network administrator to follow up.




Please Wait!

Please wait... it will take a second!