SAP Knowledge Base Article - Preview

3205642 - Connection test error for Azure datastore with a system user account in UPN format

Symptom

You are trying to test the connectivity in your Datastore connected with Azure and you are getting similars errors like the one below:

  • Test failed for the default configuration 'default' of datastore: 'abc':
    ODBC call <SQLDriverConnect> to connect database <yourserver.windows.net> failed with error: <ODBC call <SQLDriverConnect> for data source <yourserver.windows.net> failed: <[SAP BODS][ODBC SQL Server Wire Protocol driver][SQL Server]Cannot open server "company.com" requested by the login. The login failed.
    [SAP BODS][ODBC SQL Server Wire Protocol driver]Invalid attribute in connection string: DriverUnicodeType.>. 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

You are also using a system user account in UPN format.

For more details about UPN, please refer to https://docs.microsoft.com/en-us/azure/active-directory/hybrid/howto-troubleshoot-upn-changes


Read more...

Environment

  • SAP Data Services
  • SAP Cloud Integration for data services

Product

SAP Cloud Integration for data services all versions ; SAP Data Services all versions

Keywords

CI-DS, CPI, Data Services, Azure, MS SQL, UPN format, test connection failed, Cloud integration , KBA , EIM-DS-CON , Connectivity , LOD-HCI-DS , HANA Cloud Integration for Data Services , EIM-DS-CPIDS , internal only - when assigning to DS Team , How To

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.