Specifying a common name with sp_listener

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. The common_name you specify here is validated against the common_name in the SSL certificate. If you do not include CN=common_name, Adaptive Server uses server_name to validate against the common name in the SSL 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 (it can be “CN”, “cn” or “Cn”), but the attribute value for the common name is case sensitive.

For example, to specify the common name ase1.big server 1.com:

sp_listener 'start','ssltcp:blade1:17251:"CN=ase1.big server 1.com"','0'

See the Reference Manual: Procedures for more information about sp_listener.