Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 17 Apr '15, 17:47

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

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

permanent link

answered 18 Apr '15, 08:47

Graeme%20Perrow's gravatar image

Graeme Perrow
accept rate: 54%

Comment Text Removed

alt text

(18 Apr '15, 14:23) Breck Carter

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...)

(20 Apr '15, 09:44) Volker Barth

Thank you - that makes perfect sense.

(20 Apr '15, 11:01) Justin Willey
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 17 Apr '15, 17:47

question was seen: 12,362 times

last updated: 20 Apr '15, 11:01