When attempting to add a MS SQL Server connection in SAC the following error is displayed:
SAP Analytics Cloud (SAC)
Reproducing the Issue
- From the main SAC menu select "Connections".
- On the Connections screen click the "+" icon (Add Connection) in the top right corner.
- From the dropdown menu that will be presented, select "SQL Databases".
- The error will display at the bottom of the screen.
The datasource has not been configured for use by SAC.
Configuration steps for connecting to MS SQL Server are in the SAC Help file: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2018.12/en-US/bdf055159cbb4f36b26c93ccb0c56066.html
Specifically the following link discusses MS SQL Server connection configuration details:
Other useful documentation regarding datasource configurations:
KBA 2358097 - SAP Analytics Cloud connecting to on-premise data *** Master KBA ***
mssql error connect to C4A , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , How To