SQL Server Connector Release Notes

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

November 8, 2023

SQL Server OCF Connector Version 1.3.7

Compatible Alation version: 2022.2 or higher

Fixed Issues

Connection Test Fails When Using SSL with NTLM Authentication

Fixed an issue when the connection test failed when SSL was enabled with NTLM authentication. The test resulted in the following error:

Caused by: sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException:
unable to find valid certification path to requested target

To use SSL with NTLM, basic, or Kerberos authentication, use the following JDBC URL format:

sqlserver://<Host_Name>:<Port_Number>;encrypt=true;hostNameInCertificate=<certificate_name>;

This JDBC URI includes the following additional SSL related parameters:

• encrypt=true

• hostNameInCertificate=<certificate_name>

You can run the command below to verify your certificate name. In the result, check for the value after CN=. That’s the certificate name.

openssl x509 -noout -subject -in <certificate_name>.crt;

Example:

sqlserver://10.13.82.165:1433;encrypt=true;hostNameInCertificate=abc.corp.net;