Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DEV_xxx user credentials

Hi,

I hope someone can help me.

I added my hanatrial db to the list of systems and created a couple of tables there.

I am now trying to log on to the hana db using this document : Connect to SAP HANA via JDBC - SAP HANA Developer Guide for SAP HANA Studio - SAP Library


So the format would be sth like :

connection = DriverManager.getConnection("jdbc:sap://[dbURL]:30015?reconnect=true&timeout=0",[USER], [PWD]");

The property window tells me that the URL is "jdbc:sap://localhost:30015?reconnect=true&timeout=0 " (is this correct ?? )

and the USER is of type "DEV_[xxxxxxx]"

but I'm not sure how to get the password.

I assumed there was some sort of mapping to my GLOBAL ID and PW so I tried these but it seems to hang at the connection point and never succeed.


If I use the DEV_ user with my GLOBAL password (or empty) it returns a "[10]: invalid username or password" error

Where can I find or reset the DEV_xx user credentials ? or am I missing sth altogether ?

Thanks

Ollie

replied

Hi Ollie,

technically, the description you cited above is correct. However, you cannot access the database direcectly; it is protected.

So what you need to do it to open a tunnel first, using the neo command line tool. This is described in [1]. When opening the tunnel, you will be shown the user credentials which you have to use for the JDBC connection.

Your URL looks okay (the host name "localhost" is correct too).

Best Regards,

  Jürgen

[1] SAP HANA Cloud Platform

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question