- The following error occurs after pressing the 'Test Connection' button on an MS SQL database datastore in CPI-DS:
Test failed for the default configuration '<configuration>' 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][SQL Server]Cannot open database "<datastore name>" requested by the login. The login failed.>. 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.
- SQL Server Native Client (64-bit) has already been configured as per KBA 2843999.
" requested by the login. The login failed." error occurs while connecting to MS SQL database - SAP Cloud Platform Integration for Data Services"> Read more...
- SAP Cloud Platform Integration for Data Services 1.0
- Microsoft SQL Server 20xx
LOD-HCI-DS, HCI, CPI, CPI-DS, CI-DS, MS SQL, login, failed, Native Client, driver, datastore, database, connection , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem
About this pageThis 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.