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, error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:unable to get local issuer certificate , 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.
SAP Knowledge Base Article - Preview