The DCO Server determines which security service it will use for a port based on the interface file on UNIX and sql.ini file on Windows.
To enable SSL
Generate a certificate and trusted roots file for the server. For additional information, refer to Appendix A, “SSL Connectivity.”
Use sp_configure to specify the certificate file. From a command prompt, enter:
exec sp_configure <servername>, "certificate_file", <certificate file spec>
Use sp_configure to specify the trusted roots file, unless you are using the default location:
exec sp_configure <servername>, "trusted_roots_file", <trusted roots file spec>
Use sp_configure to specify the certificate password file. From the command prompt, enter:
exec sp_configure <servername>,”certificate password”, <certificate password file spec>
Add the SSL filter to the interfaces file.
Shut down and restart the server.
For more information on SSL, refer to the ASE System Administration Guide.
