SQL Server Data Connection

0
I’m currently trying to connect to a external database from SQL Server 2016, but I’m getting the following error, and I think it may be because of the drivers. 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". Any idea on what to do will be appreciated. 
asked
2 answers
0

This person had the same issue and there is an accepted answer, it might be worth checking out:

 

https://forum.mendix.com/link/space/aws/questions/127047

answered
0

Please try to use custom configuration under custom tab as I was also facing the same issue but with this configuration it started working for me.

 

Name: DatabaseJdbcUrl

Value: jdbc:sqlserver://localhost:1434;databaseName=MendixDB;integratedSecurity=false;encrypt=true;trustServerCertificate=true

answered