DS ControlPoint: Connect to a Digital Sentry DSSRV / DSSRV2 behind a router, firewall or through Network Address Translation (NAT).

Issue

Connect to a Digital Sentry video recorder from a WAN internet connection and the DVR is behind a router, firewall or NAT.

Product Line

Pelco Video Management

Environment

  • DS ControlPoint 7.15
  • DSSRV / DSSRV2
  • DS NVs

Cause

Remote connections to a DS recorder require network ports to be available.

Resolution

DS ControlPoint required network ports:

 

DS ControlPoint SQL port information:

When DS ControlPoint makes a connection to DSSRV / DSSRV2 / DS NVs recorder, it will send a request on UDP 1434 to discover the dynamic TCP SQL port for the DS_MSSQLSERVER instance.  Once the recorder responds to the request with the correct port, DS ControlPoint will then communicate with SQL using the dynamic TCP port discovered and communicate with the DS VideoServer Service using TCP18772 to complete the connection. 

If DS ControlPoint is unable to discover the correct SQL network port using UDP 1434, you might receive the following error - "Exception has been thrown by the target of an invocation" or "Object reference not set to an instance of an object". 
 

DS ControlPoint 7.15 - specify SQL port manually

With the release of DS ControlPoint v7.15 you can now specify the TCP SQL network port manually by editing the ControlPointCache.xml file.
By specifying the TCP SQL network port manually, you do not need to have UDP 1434 available and it is recommended to not expose that port over a WAN for security reasons.

 

  1. Recorder: Locate the assigned SQL port by running DS Quick Setup on the video recorder itself and navigating to DS Quick Setup > Tools button > Configure SQL Ports.

    Note:
    The port will show to be a Dynamic port but it is only dynamically assigned when the software is installed, once assigned the port is static and will not change.




     
  2. Client PC: Must have DS ControlPoint v7.15 installed for the below option to be available.
    1. If DS ControlPoint is running, close it out.
       
    2. Click on START button and in the search type in %appdata% and then ENTER.
       
    3. You should now be in the AppData\Roaming folder.  Double-click the Pelco folder.
       
    4. Right-click on ControlPointCache.xml and select EDIT.
       
    5. Locate the tag [SQLPort] 0000 [/SQLPort] under the [Name] --dvr name--- [/Name] of the System you are connecting with.

      Note: If the SQLPort tag is not listed in the ControlPointCache.xml file, the system may need to be deleted and then re-added within the Systems tab in DS ControlPoint to populate the setting.




       
    6. Change the 0000 to the port number listed in DS Quick Setup on the recorder.

      *DS ControlPoint uses discover when the SQLPort is set to 0000.

      Example using the port listed in DS Quick Setup above.



       
    7. In Notepad, click on File > Save and then Exit.
       
    8. Relaunch DS ControlPoint and verify you can connect successfully.
       


 

Related Articles:
DS ControlPoint errors when connecting to a Digital Sentry system with "A network-related or instance-specific error occurred while establishing a connection to SQL Server".

What network ports are required for a remote connection to a Digital Sentry System?