Symptoms

Error when exporting data to a database and ehilr using Microsoft OLE DB Provider for SQL Server:

Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (SECDoClientHandshakeO).]SSL Security error.

Cause

Incorrect connection method is specified.

Resolution

Use another connection method:

1. Select Use connection string option and build the connection string:
   
   
2. Choose a driver compatible with your SQL Server:
   
3. When a new connection will be created, open options and select database:
   
4. Update schemas and create tables:
   ​

Additional information

Export to a database