1

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: enter image description here

however enter image description here trust server certificate will connect to the server.

i have checked and the server does not have force connection. no certificates are installed.

2

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.

certificate

force encryption

1
  • i reinstalled the os on the client. and the server stay the same. it worked. it was an windos 10 configuration/error
    – none
    Jun 27 at 9:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.