API Gateway - Microsoft SQL Server Login Requires an SSL Connection using a wildcard certificate

Products

• CA Mobile API Gateway
• CA API Gateway

Issue/Introduction

Microsoft SQL Server 2016 is configured with a Wildcard certificate for example of wildcard certificate *.<domain>.com.

API gateway throws the following message while connecting to SQL Server using JDBC connection :

Testing failed: invalid connection properties setting.

[l7tech][SQL Server JDBC driver]The SQL server login requires an SSL connection.

 

 

 

 

 

 

Environment

Release : API gateway 10

 

Resolution

Added EncryptionMethod properties with a value loginSSL in JDBC Connection properties.

Valid values are : noEncryption | SSL | requestSSL | loginSSL

If set to noEncryption, data is not encrypted or decrypted.

If set to SSL, data is encrypted using SSL. If the database server does not support SSL, the connection fails and the driver throws an exception.

If set to requestSSL, the login request and data is encrypted using SSL. If the database server does not support SSL, the driver establishes an unencrypted connection.

If set to loginSSL, the login request is encrypted using SSL. Data is encrypted using SSL If the database server is configured to require SSL. If the database server does not require SSL, data is not encrypted and only the login request is encrypted.

 

Additional Information

https://docs.microsoft.com/en-us/answers/questions/68910/how-to-use-ssl-wildcard-certificate-in-ssrs.html

https://docs.progress.com/bundle/datadirect-connect-jdbc-51/page/EncryptionMethod_8.html