Skip to Content
author's profile photo
Former Member

"Error when connecting to system" or "Invalid Username or Password" with HANA Studio

If you are getting error message(s) with the HANA Studio (on Cloudshare desktop image) to the HANA DB after you enter the correct username or password:

a. "Error when connecting to system":

b. "Invalid Username or Password":

The issue seems to be caused by a corrupted secure storage file.

As a workaround, please follow the following steps:

1. Delete your HANA connection on the Navigator tab in HANA Studio, and then close the HANA Studio.

2. Open windows explorer, and navigate to C:\Users\Administrator folder on your Cloudshare desktop.

3. Find the folder ".eclipse" and rename it to "OLD.eclipse":

4. Open your HANA Studio and set your HANA DB Connection again. You will be prompted to set the password reminder for secure storage file. You can choose "No".

5. After that, the new ".eclipse" folder and the new secure storage file will be recreated.

6. Close and re-open your HANA Studio, to verify that the workaround fixed the connection issue.

Regards,

Ferry

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

28 Answers

  • Jul 18, 2012 at 07:09 PM

    Thanks Ferry. It's really helpful.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jul 20, 2012 at 01:26 PM

    Thanks Ferry.

    I could able to resolve my issue.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 25, 2012 at 06:07 PM

    Hi Ferry I am facing with same issue and tried with the steps that you have provided but could't resolve the issue when i rename the existing folder .eclipse with OLD.eclipse in the administrator. I could see two eclipse folder in the administrator.


    123.png (58.0 kB)
    234.png (28.0 kB)
    567.png (29.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Sep 25, 2012 at 08:29 PM

    Hi Feery,

    I am also facing similar problem , I have followed your steps ,even though still am facing same issue.

    Please have a look the attached screen shot iand help me out.

    Thanks

    Baji


    P1581377572.png (38.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Dec 09, 2012 at 03:47 AM

    Hi Ferry,

    Thanks very much!! It solved my problem.

    Siva Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Jan 14, 2013 at 09:10 PM

    Hi Ferry,

    Thanks. I could fix it on Windows😊 but now I have the problem on Linux.😭

    Please could you give me any suggestion?

    thanks

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Mar 08, 2013 at 01:29 PM

    Hi Ferry,

    I am facing database connection issue and did as per above steps but still unable to connect to database.

    In error log getting following error.

    I am using

    HANA Studio Version: 1.0.48

    JAVA (JRE7) : 7

    I have gone into the administration panel within windows and didn't found HDBODBC32 driver under Data Source ODBC.

    com.sap.ndb.studio.jdbc.JDBCConnectionStatus: Database connection is not available. See error log for more details.

    at com.sap.ndb.studio.jdbc.JDBCPlugin.createConnection(JDBCPlugin.java:314)

    at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.executeTryJDBC(SAPSystemObjectUpdate.java:203)

    at com.sap.ndb.studio.navigator.operations.SAPSystemObjectUpdate.execute(SAPSystemObjectUpdate.java:69)

    at com.sap.ndb.studio.navigator.operations.UpdateSAPSystemOperation.execute(UpdateSAPSystemOperation.java:76)

    at com.sap.ndb.studio.datamodel.controler.DataModelOperationJob.run(DataModelOperationJob.java:70)

    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

    Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to jdbc:sap://tmsap:30015 [Cannot connect to host localhost:30015 [Connection refused: connect], -813.].

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:219)

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.createException(SQLExceptionSapDB.java:203)

    at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.generateDatabaseException(SQLExceptionSapDB.java:186)

    at com.sap.db.jdbc.Driver.connect(Driver.java:239)

    at com.sap.ndb.studio.jdbc.JDBCPlugin$5.run(JDBCPlugin.java:655)


    3.JPG (79.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Rajendra,

      I am using microsoft azure instance and facing same problem.Did you able to solve the problem? If it is then help me out.

      regards

  • author's profile photo
    Former Member
    Mar 09, 2013 at 04:43 AM

    Hi Ferry,

    I signed up for the 30 day free Hana trial yesterday, however, never got an email from SAP regarding my database login information. Is there a default login information to login from HANA studio to Hana database? Please help, I lost two days already. Your help will be appreciated immensely.

    Again, I do not know the database login information or the default login info if one exists for hana.

    Regards,

    Rasheed Khan

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 04, 2013 at 01:01 PM

    Hi Ferry,

    that also fixed the same issue with HANA Studio on Linux connected to HANA on AWS.

    Thanks & best regards,

    Karsten

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 06, 2013 at 10:57 AM

    Hi Ferry,

    I tried your steps but could not solve the problem.

    Is there any other solution to resolve this?

    thank you,

    abhi

    Add comment
    10|10000 characters needed characters exceeded