SAP Knowledge Base Article - Public

3479238 - Error when trying to create an Import Connection to a named installation of MS SQL Server 2016 - SAP Analytics Cloud

Symptom

You are trying to configure an import connection to a named installation of MS SQL Server 2016 but is not being able to create the connection, even though all the prerequisites are filled as per Import Data Connection to an SQL Database. You see the following error: 

  • "Unable to connect to data source. Check your connection details then try again.
    Correlation ID: XXXXXXXXXXXXXX"

Environment

    SAP Analytics Cloud 2024.8.10

    Reproducing the Issue

    1. Login to the tenant;
    2. Go to Connections and click on + button; 
    3. Select SQL Databases option on Acquire Data;
    4. Select the desired Location and MS SQL Server 2016 on Connection Type; 
    5. Give the connection a name, and then, fill the fields (Server, Database, Username, Password)
    6. Click on Create; 
    7. See the error: 
      1. "Unable to connect to data source. Check your connection details then try again.
        Correlation ID: XXXXXXXXXXXXXX"

    Cause

    This issue is currently under investigation by the Development team.

    Resolution

    This issue is currently under investigation by the Development team.

    See Also

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

    Keywords

    SAP Analytics Cloud, SAC, connection, import connection, import, MS SQL, SQL, Server, 2016, named installation, named, Unable to connect to data source, Check your connection details then try again , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

    Product

    SAP Analytics Cloud 1.0