Mendix Console JDBC connection failed

0
Hi, i'm trying to deploy On-Prem using Mendix Console with sql server installed in the same server , but i get error " failed with SQLState: 08S01 Error code: 0 Message: ""encrypt" property is set to "true" and "trustServerCertificate" property is set to "false"" i tried DatabaseUseSsl: false in settings.yaml for the application but didn't work i tried to put DatabaseJdbcUrl , but it didn't work , i tried to disabled and enabled the DB encryption and it didn't work. another point , if i use the following DatabaseJdbcUrl it didn't overide the other values as per mendix Doc. DatabaseJdbcUrl: jdbc:sqlserver://localhost:1433;databaseName=DBName;integratedSecurity=false;encrypt=true;trustServerCertificate=true; i tried many combiations but all give the same error.   can any one share the DB YAML settings part so we can see how it suppose to be .  
asked
2 answers
0

Hello Hamed,

I had the same problem as you when upgrading an app version.

Since version 9.24.25, the version of the JDBC driver has changed.

To run our apps locally, you need to configure it in custom as follows:

DatabaseJdbcUrl jdbc:sqlserver://{urlbdd:1733};databaseName={namedatabase};integratedSecurity=false;encrypt=true;trustServerCertificate=true

 

Maybe this can help you

answered
0

Hi Eddy,

thank you for your answer , my issue was in the server i'm trying to install mendix on.

 

the resolution is to add DatabaseJdbcUrl =false in the advanced options in the app configuration

answered