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

book

Article ID: 221295

calendar_today

Updated On:

Products

CA Mobile API Gateway

Issue/Introduction

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

API gateway throws the following message whilst connecting to SQL Server using JDBC 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

Attachments