ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
API Gateway: Enabling SSL Connection for Microsoft SQL Server
Article ID: 236755
CA API Gateway
How to configure SSL JDBC connection for Microsoft SQL Server from the Gateway?
Release : 10.0
Component : API GATEWAY
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:
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