SAP Knowledge Base Article - Preview

2843999 - Unable to connect to MS SQL database using ODBC - SAP Cloud 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 Support.

  • 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 Integration for data services
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Azure SQL Database

Product

SAP Cloud Integration for data services 1.0

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 for Me (Login required).

Search for additional results

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