spacemb,

Symptom

ssltcp listener does not start with ASE server starting.
ssltcp listener can be started with command: sp_listener 'start','ssltcp:<server_name>:<ssltcp_port>:"CN=<CommonName>"'

Environment

Adaptive Server Enterprise (ASE) all version

Cause

There is one more entry of "<server_name>" without ssl in the interfaces(for Unix/Linux)/sql.ini(for Windows) file and it's location is before the ssl entry.

<server_name>
master tcp ether <host_name/ip address> <port>
query tcp ether <host_name/ip address> <port>
…
<server_name>
master tcp ether <host_name/ip address> <port>
query tcp ether <host_name/ip address> <port>
master tcp ether <host_name/ip address> <ssltcp_port> ssl="CN='<server_name>'"
query tcp ether <host_name/ip address> <ssltcp_port> ssl="CN='<server_name>'"

Resolution

Remove the entry of "<server_name>" without ssl from the interfaces file.