Adaptive Server determines which security service it will use for a port based on the interface file (sql.ini on Windows).
Generate a certificate for the server.
Create a trusted roots file.
Use sp_configure to enable SSL. From a command prompt, enter:
sp_configure "enable ssl", 1
1 – enables the SSL subsystem at start-up, allocates memory, and SSL performs wire-level encryption of data across the network.
0 (the default) – disables SSL. This value is the default.
Add the SSL filter to the interfaces file. See “Creating server directory entries”.
Use sp_ssladmin to add a certificate to the certificates file. See “Administering certificates”.
Shut down and restart Adaptive Server.
To request, authorize, and convert third-party
certificates, see the Utility Guide for information
on the certauth, certreq,
and certpk12 tools.
Unlike other security services, such Kerberos, and NTLAN, SSL relies neither on the “Security” section of the Open Client/Open Server configuration file libtcl.cfg, nor on objects in objectid.dat.
The system administrator should consider memory use by SSL when planning for total physical memory. You need approximately 40K per connection (connections include user connections, remote servers, and network listeners) in Adaptive Server for SSL connections. The memory is reserved and preallocated within a memory pool and is used internally by Adaptive Server and SSL Plus libraries as requested.
Enabling SSL 