DB Connector Error (SunCertPathBuilderException: unable to find valid certification path to requested target)

1
Hi everyone!   We are encountering the following error when trying to connect mendix 10.2 with a DB SQL server from the DB Connector module.(Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target)   The database configuration works correctly locally with the port, authentication and the custom parameter (DatabaseUseSsl=false), however, when trying to connect from the module configuration this parameter is not taken into account.   The option to add ;encrypt=false in the url is not working.  jdbc:sqlserver://localhost:52188;databaseName=SmarterMRP_DEMO;encrypt=false   If anyone has managed to solve this problem it would be helpful, Thank you so much
asked
1 answers
0

I am not using the DatabaseConnector but when I have run into similar problems in the past one of the following usually works:

Add the option trustServerCertificate=true to the connection string. 

Or alternatively you would need to add the certificate to the TrustStore in the java runtime that Mendix is using.

 

answered