JDBC Works only with User SYSTEM

[schardosin]

Hi,

I am facing a really weird behavior, in Hana Express Edition I can only connect using JDBC with the user SYSTEM.

I have created a bunch of other users, all of them are able to login using the workbench or console tools, but by using JDBC, I can connect only with SYSTEM user.

Is there any configuration for that? This is new to me, using SCP or any other Hana instance I have never faced this problem.

Steps:

1) Create a user: create user TEST password TEST

2) Try to login using workbench (works successfully).

3) Try to connect using JDBC. It gives [10]: authentication failed

The strange part is that with SYSTEM user it works, I have also granted admin roles to my new user, even with that the connection doesn't work.

I would appreciate any help here.

Thanks

[carlsoane]

Hello Rafael:

Did you follow these instructions for building your jdbc connection string.

Here is an example for how to connect to the systemDB on an HXE server with the user "SYSTEM" and the password "manager".

jdbc:sap://localhost:39013/?databaseName=SystemDB&user=SYSTEM&password=manager

Thanks,

Carl

[jonas_rabello]

Thank you Carl.

This was what I needed. My connection finally worked.