In windows 10 , Test connection with a udl file is successful. however, if "Use Encryption for data" was changed the to true. UDL Use Encryption the connection fail with error message:
"[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security Error.
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security Error.
The same message is presented when a simple Delphi app That I wrote to connect the SQL Server. This is the only computer it is happening in. Where to disable the OS rule that require apps to use encrypted connection?
using the management studio with this configuration will yeild error message:
however trust server certificate will connect to the server.
i have checked and the server does not have force connection. no certificates are installed.