If your SQL Server instance is configured to request an encrypted connection (ForceEncryption set to Yes), you must use the SSL version of the SQL Server ODBC driver. Otherwise, your connection will fail with the error "Client unable to establish connection: SSL requested but not supported."
To use the SSL version of the SQL Server ODBC driver, in your data source, set the Driver
attribute to Easysoft ODBC-SQL Server SSL
. For example:
[MY_SQLSERVER_DATA_SOURCE] Driver = Easysoft ODBC-SQL Server SSL Server = MYSQLSERVERMACHINE\MYINSTANCE User = MYDOMAIN\myuser Password = mypassword Encrypt = No