SAP Knowledge Base Article - Preview

3125084 - "[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "<datastore name>" requested by the login. The login failed." error occurs while connecting to MS SQL database - SAP Cloud Platform Integration for Data Services

Symptom

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

Environment

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

Product

SAP Cloud Integration for data services 1.0

Keywords

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