Weird SSL SQL Server Error

OK, this was a new one for me.  Trying to connect to an Azure database from CF 2016 and got an error:  “The SQL server login requires an ssl connection”.  This one had me stumped until I found this solution:  In the “Connection String” box, enter “EncryptionMethod=SSL;”.  It’s in the advanced settings section, I’d never noticed it before.  Entering that took care of it though!  Thank goodness I didn’t have to mess around with drivers or jar files to fix this.

Mel