Server Ports used by SQL Anywhere

[justin_willey]

By default a SQL Anywhere database engine uses port 2638. You can specify an alternative port to use with

 -x tcpip(ServerPort=xxxxx)

If no alternative is specified and the engine cannot use 2638 (because there is already a SQLA server or another application using it) then the database engine selects another port instead.

My question: is there a standard list of ports that SQLA tries to use after 2638? I see that 49154 often comes up, for example.

[graeme_perrow · Accepted solution]

We start at 49152 and just keep going up from there until we find a port that is not being used.

[Breck_Carter · Accepted solution]

[VolkerBarth · Accepted solution]

Just to add:

The usage of 49152 and above should not come as a surprise, those are the port numbers reserved for dynamic/ephemeral ports, cf. Wikipedia.

(No, I ain't saying every answer to any of Breck's questions is addressed by a fitting RFC...)

[justin_willey · Accepted solution]

Thank you - that makes perfect sense.