API Gateway: Enabling SSL Connection for Microsoft SQL Server
searchcancel
API Gateway: Enabling SSL Connection for Microsoft SQL Server
book
Article ID: 236755
calendar_today
Updated On: 03-11-2022
Products
CA API Gateway
Issue/Introduction
How to configure SSL JDBC connection for Microsoft SQL Server from the Gateway?
Environment
Release : 10.0
Component : API GATEWAY
Resolution
If the Microsoft SQL Server is using trusted CA then no additional configuration is required at the Gateway server level. The Gateway Java verifies the Microsoft SQL Server certificate using the default CA certificates located in $JAVA_HOME/lib/security/cacerts.
If your Microsoft SQL Server is using a self-signed certificate or non-default trusted CA, then you need to import the CA (root and other intermediate certs) into a Java trust store. Here are the steps to create a trust store on the Gateway:
Create a folder as "/opt/SecureSpan/truststore"; make sure this folder has 755 permission
Go to this newly created folder and run this command to create a trust store and import the cert
TrustStorePassword = <password that you used while creating this trust store>
Here is a sample configuration:
Additional Information
The DataDirect driver documentation has more information on the supported additional parameters. You can read more about this here: https://docs.progress.com/bundle/datadirect-connect-jdbc-51/page/Connection-Properties_8.html