Skip to Content
0

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

Jan 05, 2017 at 12:59 PM

1.6k

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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.

Share
10 |10000 characters needed characters left characters exceeded