how to disable encryption on SQL server 2014 connection that SSL is enforced by windows

Question

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?

Update:

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.

Answer 1

try to review wheter the encryption is forced or not:

in sql server configuration manager

• Expand SQL Server Network Configuration and right-click on Protocols for , then click Properties.
• On the Certificate tab, unselect certificate.
• Select No in the ForceEncryption box, then click OK.

To apply the configuration you have to restart sql server.

Answer 2

Not a fan of Windows, and just needed to get the database out from a backup file. Did not want to worry about SSL certificates etc. If you are not doing on this production, there is an easy way around it. Simply:

1. From the screen below, simply click on "Options >>"

2. Simply unselect "encrypt connection" and select "trust server certificate"

That worked for me! But this should not be used in production!