2758294 - LDAP Authentication using ODBC - Error "[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;10 authentication failed"

Symptom

Testing an HANA ODBC connection with an LDAP user fails with the following error:

The validation of LDAP provider is successful: VALIDATE LDAP PROVIDER <provider_name> CHECK USER * PASSWORD
The indexserver trace shows the following:

7404]{-1}[-1/-1] 2019-01-11 12:37:15.043297 d Authentication ManagerAcceptor.cpp(00361) : Method is applicable: SCRAMSHA256

[57404]{-1}[-1/-1] 2019-01-11 12:37:15.043305 d Authentication ManagerAcceptor.cpp(00370) : evaluate was not successful for method: SCRAMSHA256
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043662 d Authentication AuthenticationInfo.cpp(00039) : ENTER getAuthenticationInfo (userName=xxxxxxx)
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043760 d Authentication Connection.cc(03178) : [AUTHENTICATION] logon name: xxxxxxx, external name: isldapenabled: 1
[57404]{-1}[50/-1] 2019-01-11 12:37:15.043769 d Authentication Connection.cc(04042) : [PRE AUTHENTICATION] logon name: xxxxxxx
[57404]{-1}[51/-1] 2019-01-11 12:37:15.045915 e Authentication catalog_authmgr.cc(00503) : Unexpected exception occurs in CatalogAuthMgr::invalidConnect: authentication failed
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.046038 d Authentication Connection.cc(03246) : exception during authentication: ERROR [SQL-10] authentication failed at ptime/query/catalog/catalog_authmgr.cc:927
exception 1: no.71000010 (ptime/query/catalog/catalog_authmgr.cc:927)
ptime::PtimeException
NO exception throw location recorded. Stack generation suppressed.
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414749 d Authentication ManagerAcceptor.cpp(00044) : Prepare authentication: adding available methods
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414767 d Authentication Manager.cpp(00115) : getMechs: provided mechanism=SPNEGO
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414769 d Authentication Manager.cpp(00115) : getMechs: provided mechanism=Kerberos 5
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414781 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method GSS
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414787 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method SAML
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414791 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method SAPLogon
[57404]{-1}[-1/-1] 2019-01-11 12:37:15.414795 d Authentication ManagerAcceptor.cpp(00051) : Prepare authentication: added method JWT

Environment

SAP HANA 1.0
SAP HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

LDAP Authentication using ODBC, LDAP, ODBC, CommonCryptoLib , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.