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 har traces 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 Details, 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

  • KBA: 2569847 - Where can you find user assistance (help) for SAP Analytics Cloud to use, configure and operate it more effectively?
  • Ask a question on the SAP Community!
  • KBA: 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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