Very useful tool for checking SQL and RMS device ports are open and active.

[Jeremy Wingate]

The below windows tool is ideal for confirming that suitable ports are open from Web server to SQL server. The tool can also be used to confirm port 80 is open to RMS software... however note that the software will only test communication from the PC running it >> RMS server. Most connection issues are due to RMS devices not having network access to RMS server.

Still perhaps useful.

https://www.microsoft.com/en-us/down....aspx?id=24009

Guidance
https://docs.microsoft.com/en-us/troubleshoot/sql/connect/resolving-connectivity-errors#using-portqryui-tool-with-sql-server

[Jeremy Wingate]

Additional approach here... is to open CMD and run the below command (including quotes). Assumes user has ,net v4.7.2 installed.

This will attempt to communicate directly with the device service software (same as RMS devices). If the PC running this test has same domain access and IP address as the RMS device it should prove that network access is granted to RMS server. This means you typically cannot use an end user PC that will have wider domain access vs a 'foreign' PC on the network.

If successful CMD will successfully download a file called DeviceService.cs (file and contents are irrelevant ... that fact the download is successful is key). If an error is triggered there is an issue that requires investigation.

Update the host name below for local RMS installations.

"C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.7.2 Tools\x64\svcutil.exe" http://rms.rotronic.com/wService/wService3.DeviceService.svc?singleWsdl


Example sucessful response

Microsoft (R) Service Model Metadata Tool
[Microsoft (R) Windows (R) Communication Foundation, Version 4.7.3081.0]
Copyright (c) Microsoft Corporation. All rights reserved.

Attempting to download metadata from 'http://localhost/wService/wService3.DeviceService.svc?singleWsdl' using WS-Metadata Exchange or DISCO.
Generating files...
C:\DeviceService.cs

[tenny0]

This will make an effort to speak with the device service software directly (same as RMS devices). If the PC performing this test shares the same IP address and domain as the RMS device, it should be demonstrated that the RMS server has network connectivity. As a result, you usually can't utilise an end user PC that will have more domain access instead of a PC that is "foreign" to the network.

[tenny0]

The Windows programme shown below is perfect for making sure that the appropriate ports are open between the Web server and SQL server. However, keep in mind that the programme will only test connectivity from the PC executing it >> RMS server. The utility may also be used to validate if port 80 is available to RMS software. The majority of connection problems are brought on by RMS devices' lack of network connectivity to RMS servers.

[ahmedsayeed1982]

The below windows tool is ideal for confirming that suitable ports are open from Web server to SQL server. The tool can also be used to confirm port 80 is open to RMS software... however note that the software will only test communication from the PC running it >> RMS server. Most connection issues are due to RMS devices not having network access to RMS server.

Still perhaps useful.

https://www.microsoft.com/en-us/download/confirmation.aspx?id=24009

Guidance
https://docs.microsoft.com/en-us/troubleshoot/sql/connect/resolving-connectivity-errors#using-portqryui-tool-with-sql-server

[/URL]

Thanks a lot Jeremy.