sp_listener includes the CN=common_name parameter, which allows you to specify a common name for the SSL certificate. The syntax is:
sp_listener 'command','[protocol:]machine_name:port_number: "CN=common_name"', 'engine_number'
Where CN=common_name is used only if you specify ssltcp as the protocol. If included, it uses the specified common_name to validate the common_name in the SSL certificate. If you do not include CN=common_name, Adaptive Server uses server_name to validate the common name in the SSL certificate. CN=common_name must match the common name entry in the certificate. If you include a fully-qualified domain name in the certificate, it must match the CN=common_name.
The attribute name “CN” is case insensitive, but the attribute value for the common name is case sensitive. For example, the attribute name may be “CN,” “Cn,” or “cn.”
For example, this specifies the common name ase1.big
server 1.com:
sp_listener 'start','ssltcp:blade1:17251:"CN=ase1.big server 1.com"','0'
See the Adaptive Server Reference Manual for more information about sp_listener.
