cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member187605
Active Contributor
0 Kudos

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?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

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.

Answers (0)