Skip to Content
1
Sep 19, 2019 at 03:02 PM

SAP HANA ODBC connection successfully tests but fails authentication when used.

2978 Views

I've installed the SAP HANA Client on Windows 10 and I'm trying to use the included ODBC driver. I've successfully created and configured a connection to our database. The connection passes a test connection but when I actually use this connection I always get an authentication failure. I've repeated this test in SSIS, Wherescape, and QLIK. I've tried both the 32 bit and the 64 bit ODBC installations with the same results. Are there any specific permissions or configuration that the HANA account needs to have to use ODBC? We have a hosted HANA database that is multitenant. The account works with HANA Studio.