SQL Server with Mendix Service Console

0
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
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.

 

Thanks!

answered