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.
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.