When I enable encryption and explicitly trust the server's TLS certificate with the MSOLEDB.1 provider, I get the the following error:
This used to only happen when TrustServerCertificate is FALSE on previous providers. With MSOLEDB.1, the TrustServerCertificate setting does not seem to make a difference.SSL Provider: The certificate chain was issued by an authority that is not trusted.
How can I make encryption work on the new provider without trusted certificates? We will typically use trusted certs in production, but not in other environments.
Thanks,
Carl