If the data source connects to a instances with TLS, Try adding Encrypt=yes to the connection string. Depending on different configurations, you may also have t include trustServerCertificate=true. The following documentation has a chart of the different settings, client and server, and how it affects encryption:
Using Encryption Without Validation
Sue