Skip to Content
0

Connecting HANA using ODBC with SSL

Aug 25, 2017 at 07:12 AM

260

avatar image
Former Member

I am trying to connect HANA from MS SQL Server. The first step is to create DSN using the HANA client ODBC driver. When I test the connection, I face the following error. HANA only allows SSL connection for TLS 1.2. How can I fix the error? Do I need to install any certificate?

Thanks!

SQLSTATE: 08S01

NATIVE ERROR: -10709

MESSAGE TEXT: [SAP AG] [LIBODBCHDB DLL] [HDBODBC] Communication link failure; -10709 Connection failed

RTE: [300012] Cannot create SSL engine: The message received was unexpected or badly formatted

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

1 Answer

Michael Healy
Aug 27, 2017 at 04:33 PM
1

It seems you have SSL configured on your HANA system. You also have to make sure the ODBC connection is also using SSL. HANA will reject all connections that are not SSL configured. See the HANA Security Guide and the Admin Guide for more info.

https://support.microsoft.com/en-us/help/933430/clients-cannot-make-connections-if-you-require-client-certificates-on

Share
10 |10000 characters needed characters left characters exceeded