DB Connector Error (SunCertPathBuilderException: unable to find valid certification path to requested target)
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
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.