Kbase P6868: How to limit the port range for SQL-92 to go through the firewall
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/11/2010 |
|
Status: Verified
GOAL:
How to limit the port range for SQL-92 to go through the firewall
FACT(s) (Environment):
Progress 9.1x
All Supported Operating Systems
OpenEdge 10.x
FIX:
Use -minport and -maxport as server startup parameter. Each _sqlsrv2 process spawned requires a TCP port. The port selection is limited by the -minport and -maxport settings. The sqlsrv2 process only uses ports starting from what is specified with -minport until what is still available through -maxport. The -minport and -maxport database startup parameter does not reserve the ports specific for use by Progress. Instead these parameters identify a range of ports that the _sqlsrv2 process can use if they are available and not being used by something else on the machine at the time that the _sqlsrv2 process is spawned.
Syntax for -minport -maxport:
proserve sp2k -n 66 -Mn 10 -Ma 10 -Mpb 4 -N tcp -S 9000 -ServerType 4GL -minport 9100 -maxport 9150
proserve sp2k -m3 -Ma 5 -Mpb 5 -N tcp -S 8000 -ServerType SQL -minport 8200 -maxport 8210