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

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;

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

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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