Frequently Asked Question
Using the Microsoft Port Query Utility to test connectivity of wireless sensors/gateway hub to database
Last Updated 4 years ago
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.
- Download the Port Query Tool: https://documents.evolveplus.com.au/s/5dDVJJTmWBFfB1g
- Unzip OR Extract the Port Query Tool Files
- Launch the Microsoft Port Query program, which will be located:
C:\Downloads\PortQryUI\portqueryui.exe
Note: Replace C:\Downloads with the actual path where the applications have been installed.
- Enter the Destination IP address of the database server used when installing IMMOTION
- Select the Manually input query ports option.
- Enter the Ports to query:
- Default IMMOTION Port is, enter: 55555
- Protocol: TCP
- 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
- 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.