SAP Knowledge Base Article - Public

2741924 - "Unable to Connect. Please ensure that the connection details are correct" error in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


The following error can be found in the Google Chrome Developer Tools when creating a MS SQL Server connection "{\"code\":\"ERROR_INVALID_CONNECTION_INFO\",\"rawError\"..."httpStatus\":500}"} in SAP Analytics Cloud (SAC)

  • "Unable to Connect. Please ensure that the connection details are correct" is shown as a popup error


  • SAP Analytics Cloud 2020.2.1
  • Microsoft SQL Server 2016

Reproducing the Issue

  1. Log in to SAP Analytics Cloud
  2. Create a new Import Data Connection to SQL Database (Microsoft SQL Server)
  3. Add the connection name in the format (Server\Instance:Port)


The connection details are in the incorrect format.


Please make sure in the Database field, under Connection Detials, the correct Database name is being used, instead of the Instance.

If you wish to connect to a particular instance, please use the format below;

To Access Tables in the DB

  • Server (host:port) - <IP_Address>:<Port>

To Access a Particular Instance

  • Server (host:port) - <IP_Address>\<Instance_Name>:<Port>

For more information please visit the documentation below;

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0