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.
This person had the same issue and there is an accepted answer, it might be worth checking out: