Cannot use port below 1024 in SQL Server PI repository connection details installer popup (4228198)

Unable to add a port below 1024 in the Port (optional) field in the SQL Server PI Repository Connection Details popup when creating a new SQL Server PI repository. An exclamation point symbol in red appears when entering a low port value.

The minimum default value set in the view for the port number is 1024. This configuration setting goes back to the Performance Analysis product.

The maximum port number is 65535.

WORKAROUND 1

Use a TCP port value of 1024 or higher.

WORKAROUND 2

Using a Foglight user with the Cartridge Developer role, a view change can be made in the Foglight UI to change the minimum port value. Please note that any upgrades or resets of the SQL Server cartridge with restore the default minimum port number.

1. Navigate to Configuration | Definitions
2. Navigate to Databases | SQL PI Repository > Installer
3. Select Views pull-down item 
4. Click MSSQL Repository Connection Details - Grid
   
5. Click Port Number (nested) {this is the seventh row from the bottom}
   
6. Click the Edit button
   
7. Click the Configuration tab
   
8. Click Icon in the Min Value row
9. Click Edit in Popup
   
10. Change value to 511.0
11. Click Set button
    
12. Click Save button
    

RESOLUTION