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

[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 Member]

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 Member]

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 Member]

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 Member]

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