SAP Knowledge Base Article - Preview

2843999 - Unable to connect to MS SQL database using ODBC - SAP Cloud Platform Integration for Data Services

Symptom

  • The test connection of an MS SQL database datastore is failing with the below error message in CPI-DS:

    Test failed for the default configuration '<configuration name>' of datastore: '<datastore name>':
    ODBC call <SQLDriverConnect> to connect database <<database server name>> failed with error: <ODBC call <SQLDriverConnect> for data source <<database server name>> failed: <[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECDoClientHandshake()).>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Su

  • ODBC Driver for SQL Server is installed and can be found in "DSN System" tab in ODBC Data Source Administrator.

    ODBC Data Source Administrator

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Cloud Platform Integration for Data Services
  • Microsoft SQL Server 20XX

Product

SAP HANA Cloud Integration 1.0 for data services

Keywords

LOD-HCI-DS, HCI, CPI-DS, CPI, ODBC, driver, DSN, database, connection, Microsoft, datastore, SQL, server, client , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

About this page

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

Search for additional results

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