User receives errors testing MSSQL adapter: ]SSL Security error.

Diagnostics

Product: Adapters

Release: 8207

Primary OS: Windows

Solution Date: 2020-10-16

Symptom

(FOC1400) SQLCODE IS 18 (HEX: 00000012) XOPEN: 08001

(FOC1500) : Microsoft OLE DB Provider for SQL Server: [08001]

(FOC1500) : [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

(FOC1405) SQL PREPARE ERROR.

RETCODE 18

Test for SQLMSS had data access error, test failed.

Problem

The user receives the error messages above while testing the MSSQL (OLE DB) adapter.

Solution

The SQL Server Database instance is configured with TLS 1.2 and the OLE DB version used does not support TLS 1.2. Enabling TLS 1.0 on the SQL Server Database instance resolved the issue.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.