Skip to Content

Can't connect to SQL databases from SAP Analytics Cloud

Hello everyone,

I'm trying to create a model in SAP Analytics Cloud but is showing a message about the database driver misconfigured:

Any suggestion about that? All my services are running good.

Regards.

error.jpg (63.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 01, 2017 at 07:07 PM

    Thank you very much for your answer Tammy.

    The failure was the sqljdbc.jar that I donwloaded. The correct file is in the official page of Microsoft:

    https://www.microsoft.com/en-us/download/details.aspx?id=55539

    That's solve my issue.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 27, 2017 at 08:43 PM

    Hello Juan,

    Have you followed the steps in the SAP Help to import the connection?

    See https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2017.15/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Tammy, thanks for your help.

      I follow the steps and did it the step of the environment variable:

      If you choose to use an environment variable, restart the agent as follows:

      • If you're running Tomcat as a Windows service: Restart the Tomcat service by using the Tomcat configuration manager.

      I created the same in variables for administrator and system variables.

      The .properties files is configured:

      MS SQL Server 2014=C:\Program Files\Apache Software Foundation\Tomcat 8.5\lib\sqljdbc43.jar

      I restarted the Tomcat and nothing happens.

      Thanks for your answer.

  • Oct 27, 2017 at 09:08 PM

    Hi Juan - would you please review this SAP Note? https://launchpad.support.sap.com/#/notes/2403538 I hope it helps

    Add comment
    10|10000 characters needed characters exceeded