Symptom
- The following error is dropped by pressing the "Test Connection" button on an MS SQL database on Azure PaaS datastore:
Test failed for the default configuration '<datastore configuration>' of datastore: '<datastore name>':
ODBC call <SQLDriverConnect> to connect database <<server name>> failed with error: <ODBC call <SQLDriverConnect> for data source <<server name>> failed: <[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open server "<server>.com" requested by the login. The login failed. - MS Active Directory user (like <name>@<server>.com) is used in the datastore configuration.
Read more...
Environment
SAP Cloud Integration for data services
Product
Keywords
LOD-HCI-DS, CPI-DS, CI-DS, HCI, HCI-DS, MS SQL, Azure, PaaS, Active Directory , 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.