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

Symptom

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

Environment

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

Cause

The connection details are in the incorrect format.

Resolution

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;

https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-2017

See Also

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

Keywords

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

Product

SAP Analytics Cloud 1.0