Cole
Thank you for the response. We are actually okay with the RSP User Kerberos ticket being generated. We are able to run kinit and klist to see ticket for RSP:
[username@linuxhost /]$ kinit
Password for username@COMPANY.COM:
[username@linuxhost /]$ klist
Ticket cache: FILE:/tmp/krb5cc_40293
Default principal: username@COMPANY.COM
Valid starting Expires Service principal
09/27/2018 10:57:02 09/27/2018 20:57:02 krbtgt/COMPANY.COM@COMPANY.COM
renew until 10/04/2018 10:56:25
We believe the issue is the correct ODBC or JDBC connection details for HANA. Here is the string we tried and the error received:
odbcconn <- odbcConnect("HD2")
For ODBC we are using these details (odbc.ini):
AuthMech=1
KrbFQDN=hana.company.com
KrbRealm=COMPANY.COM
KrbServiceName=krbtgt/COMPANY.COM@COMPANY.COM
This is the error/message we are receiving:
Warning messages:
1: In RODBC::odbcDriverConnect("DSN=HD2") :
[RODBC] ERROR: state 08S01, code -10709, message [unixODBC][SAP AG][LIBODBCHDB SO][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[200106] Protocol error, invalid authentication packet (m_server_at_my_company.com:30050))
2: In RODBC::odbcDriverConnect("DSN=HD2") : ODBC connection failed
If we use the UID and Password in the connection shown above we are able to access HANA:
> odbcconn <- odbcConnect("HD2",uid="user",pwd="xxxx")
Any help on connection details is appreciated for ODBC or JDBC.