3625348 - Datasphere error: Cannot load trust store. SSL Error Queue: Invalid attribute in connection string: DriverUnicodeType

"Microsoft SQL Server" connection validation error:

Connection "XXXXX" is valid, but not all features are available.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.
- Remote tables are enabled.

Data Flows: Cause: Open request could not be performed due to error: Cannot load trust store. SSL Error Queue:
Invalid attribute in connection string: DriverUnicodeType.
Replication Flows: Cause: Open request could not be performed due to error: Cannot load trust store. SSL Error Queue:
Invalid attribute in connection string: DriverUnicodeType.

If you set "Use SSL" to true and input the hostname, the validation error will be:

Connection "XXXXX" is valid, but not all features are available.
- Data flows can’t be used because of errors in the connection.
- Replication flows can’t be used because of errors in the connection.
- Remote tables are enabled.

Data Flows: Cause: Open request could not be performed due to error: SSL issuer certificate of a locally looked up certificate could not be found.
SSL Handshake Failure reason [error:0D0680A8:asn1 encoding routines:asn1_check_tlen:wrong tag][error:0D07803A:asn1 encoding routines:asn1_item_embed_d2i:nested asn1 error].
Invalid attribute in connection string: DriverUnicodeType.
Replication Flows: Cause: Open request could not be performed due to error: SSL issuer certificate of a locally looked up certificate could not be found.
SSL Handshake Failure reason [error:0D0680A8:asn1 encoding routines:asn1_check_tlen:wrong tag][error:0D07803A:asn1 encoding routines:asn1_item_embed_d2i:nested asn1 error].
Invalid attribute in connection string: DriverUnicodeType.

• SAP Datasphere
• "Microsoft SQL Server" Connection Type

KBA , DS-DI-CON , Connections , EIM-DS-DI , DI, DWC, Data Suite usage of DS-Lite , Problem