SAP Knowledge Base Article - Preview

3152852 - SQL Server connection fails with ODBC Driver 18 - NetWeaver

Symptom

- SQL Server connection fails with ODBC Driver 18

- Developer trace dev_w* shows the following error message:

C INFO: Unknown driver is being used: [ODBC Driver 18 for SQL Server]. Check note 2656107 for supported drivers. 
C  INFO: The highest known driver is: [ODBC Driver 17 for SQL Server]
C  ODBC Driver chosen: ODBC Driver 18 for SQL Server native
C  ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3241]
C  (-1) [08001] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate]
C  2 times error (0,0) or (-1,0) in sequence

Or

ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3295]
(-1) [08001] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed:self signed certificate 
1 times error (0,0) or (-1,0) in sequence
ERROR: -1 in function SQLConnectWithRetry (SQLConnectWithRetry) [line 3295]
(-1) [08001] [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection
Connection 0 failed using Driver=ODBC Driver 18 for SQL Server

Or 
SSL Provider: [1425F102:SSL routines:ssl_choose_client_version:unsupported protocol][error140B40C7:SSL routines:SSL _do_handshake:peer did not return a certifcate]  


Read more...

Environment

  • SAP Systems based on SAP NetWeaver
  • Microsoft SQL Server 2005 and higher

Keywords

ODBC Driver 18,error:1416F086 , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.