Hi all! I am having a problem deploying an application via mendix service console. Due to a bug in the jdbc drive, I can't connect to the SQL server, as it asks for a certificate. In the app I have configured the driver correctly, and if I deploy it directly from Mendix studio pro it connects to the db without problems. This is the error I get: ‘Message: “”encrypt’ property is set to ‘true’ and ‘trustServerCertificate’ property is set to ‘false’ but the driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption: Error: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target’. The issue is that I need to deploy it with Mendix Service Console in order to get it to IIS, any idea how to modify this? I found some help here as context: https://community.mendix.com/link/space/databases/questions/130960 Thanks
asked
Carlos Morales
1 answers
0
I've just solved it. When you create the app in service console, in the advanced options in the java configuration you can add variables-keys and there add the connection string to the db.