Deployment on onpremises server

0
Hello all, I am deploying am on on prim server where i did all the setup including mendix service console , sql db etc but when am starting the service am getting   Opening JDBC connection to SATISH/chemical failed with SQLState: 08S01 Error code: 0 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. ClientConnectionId:1e12f808-aa0b-4436-8624-b6f99b3eb936", retrying...(2/4)        this error .In this case everything is checked TCP/IP is enabled , username and password is also correct   also for this error i have changed settings.yaml file which is generated by mendix service console which includes database configuration still the error persist . please help me regarding this  attaching the ss of settings.yaml file    
asked
1 answers
0

Hi;

 

Most probably you SQL server either does not have a signed certficate from a trusted CA or it's certificate is already expired. Best solution option is to obtain a new certificate for SQL server from a trusted CA and install it. 

 

Alternativeley; you can either accept selfsigned certificate trust by adding "encrypt=true, trustServerCertificate=true" to settings.yaml or set "encrypt=false" (which is mainly for testing whether the connection is working but not recommended for production).

 

Please accept my answer if it helps you on your issue.

answered