Authentication by current operating system user

[former_member278106]

Dear HANA Dev Team,

I've configured HANA SSO with Windows Active Directory. It works fine for ODBC connections, but I can't add system in the HANA Dev Studio with "Authentication by current operating system user" option. I receive the error: "SAP DBTech JDBC: [1033]: error while parsing protocol". I am in the 1.00.23_0356965 version. Please advise.

Thanks, Lev

[Former Member]

Hi Lev, I saw you said your ODBC environment using kerberos to HANA works fine, and I want to know how to test kerberos connectivity to HANA with ODBC. what is the connection string? My connection string is:

Driver= {HDBODBC};ServerNode=IP ADDRESS:30015;UID=aduser1@DOMAIN NAME

but it does not work, what it should be? please give me some suggestion about how to fix this, it would be very appreciated. Thanks in advance.

Best regards,

David.

[stanislav_sidnev]

Hello Pat,

good that you remind me about that thread. I reconfigured all from the start using How To file from Note 1837331 and hdbkrbconf.py from Note 1813724. After this SSO works just fine. So try this for sure.

wbr, Stanislav

[Former Member]

I can also confirm same problem on Rev 1.0.52 374886 and I am checking if anyone has found a work around?

[stanislav_sidnev]

Hello.

Confirmed same problem in 1.00.52.374886 version.

Is there any solution for this?

[syed_ahmed11]

Marc-

We are using version 26, but still getting "SAP DBTech JDBC: [1033]: error while parsing protocol" error. 

Confirmed below steps:

FQDN Name of HANA server is matching with the Klist output.

In the external ID field, do we need to give user's Windows AD full name i.e. syed.ahmed@company.com or it is the Service User Name which we used for creating the Key tab file?

Appreciate the direction to resolve this issue.

Thanks

Syed

[former_member205400]

Guys, Did this ever get resolved. I'm having the same issue.

Mike

[former_member278106]

Hi Mike,

I've just rechecked it in the R40 version and it works very well.

Lev

[former_member205400]

Lev,

I am on hana studio ver 1.032.201206211814.

I created a hdbuserstore like:

     hdbuserstore set hdbmike myhana.mycompany.com:38215 ntid_mike my_pwd

I logged into the hdbsql client like:

     hdbsql -n myhana.mycompany.com:38215 -i DI5 -sslkeystore hdbmike

I executed a listing of the schema as per below and get the error message:

hdbsql=> \ds

* 1033: error while parsing protocol:  SQLSTATE: HY000

hdbsql=>

Am I doing something wrong here?

Mike

[Former Member]

Hi,

My HANA Studio is 1.0.48 and HANA is 1.00.36.366896

I am receiving same error. SAP DBTech JDBC: [1033]: error while parsing protocol

Is there a upgrade available for HANA?

[lbreddemann]

Hi Mike,

yep, you do.

Try

hdbsql -U hdbmike

instead.

- Lars

[former_member205400]

Lars,

That seemed to work without an error message.

However when I get logged in and exe \ds sometimes I get thrown back to the command prompt, and sometimes it sits there. See my image.

I'm on sp45 and have both the x64 and x32 client bit versions installed.

Mike

[lbreddemann]

Before running the \ds command, could you please pres [ENTER] after getting the first prompt?

- Lars

[Former Member]

Hi,

I upgraded both Hana and Hana studio to revision to 48. It is giving me error when I try to domain authentication.

I can test the authentication against domain in Linux using kinit command and output of Klist shows me right FQDN.

Please help as I want to deliver this as pesentation for university assignment.

Angad 😞

[former_member205400]

Lars,

It didn't really make any difference.

Mike

[lbreddemann]

Mike,

it indeed did

Now we know: you are in fact correctly connected to the DB.

Unfortunately there seems to be a bug that you're hitting a bug with the \ds function that leads to the immediate termination of the hdbsql toll ...

BTW: I wasn't able to reproduce it with revision 53... so maybe this one got already fixed.

- Lars

[former_member278106]

It was a bug in the version.

[Former Member]

Hi Lev,

  What version fixed the issue?

[former_member93896]

Hello Lev,

try it with revision 24 of the HANA studio. If it does not work, please open a customer message so SAP support can analyze the issue.

Regards,

Marc

SAP Customer Solution Adoption (CSA)

[former_member278106]

Hi Marc,

In rev 24 it also doesn't work.

Thanks,

Lev

[Former Member]

Hi Marc,

I have configured HANA SSO with AD following up the HowTo_HANA_SSO_Kerberos_v1.6.1.pdf in https://service.sap.com/sap/support/notes/1837331, but I don't know how to test it in odbc environment. is there any way to test it with odbc driver?  I make some code using c#, but I am not sure what the connection string with kerberos it should be, would you please give me some advise, thanks in advance.

Best regards,

David