Skip to Content

Only SYSTEM user can connect to HANA with ODBC, others cannot

I can connect from a Linux Suse ODBC client with the SYSTEM user to my HANA db. No issues. But when I try with another user, I get an "[SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed" error message:

The SAP_CMS user is not a resticted one, ODBC access is not disabled. And I am able to connect from hdbsql, too:

Which roles or privileges am I missing?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2017 at 09:25 AM

    Hi Dirk,

    "Authentication failed", so an invalid user/password, not just missing permissions. From the hdbsql syntax I can see you are connecting to the CI7 database, so this is obviously a multi-tenant database hana system. Most likely the SAP_CMS user does not exist in the database pointed to in the ODBC connection. The SYSTEM user will of course be able to connect to any database. Please check to see whether the port number in the ODBC connection corresponds to the tenant database in which the SAP_CMS user exists. You can find the port number for the tenant database in the M_SERVICES system view as described here:

    https://help.sap.com/saphelp_hanaplatform/helpdata/en/44/0f6efe693d4b82ade2d8b182eb1efb/frameset.htm.

    HTH

    Koen.

    Add comment
    10|10000 characters needed characters exceeded