how to get connected to sap HANA db

[Former Member]

hi everyone,

i am new to HANA. and i was looking to access sap hana db.i already got installed sap client and studio on my laptop, and further looking for system access and came across this blog which narrated the way to access HANA DB for the period of 30 days.

http://rbranger.wordpress.com/2013/04/06/using-hana-on-cloudshare-part-1-setup-connectivity/#comment...

Followed the steps mentioned in the link, but stuck at the point after system allocated  8gb ram and space to work. but later navigating to next page, it asked me to install the missing addon's. and lost everything ..how can i gain the access to the system allocated to me using SAP HANA Studio.

please go through the attached screenshot, where i lost myself after configuring the system

[Former Member · Accepted solution]

Hi Chowdary:

Which browser of your machine is using, I think that you need to install plugin of browser for use cloudShare environment, so you did not miss anything, i think.

So it is only plugin of browser.

Besides, I am using browser of Chrome, after I installed plugin of browser, it is work well.

Regards

Jerry.

[Former Member · Accepted solution]

hi Jerry,

i am using Mozilla Firefox. i got addon installed and it prompted me to restart the browser. Later i missed the screen i referring too..

can you help me step by step procedure, to get access to the system. If you can provide me any document that can help me, will also be okay for me..

[Former Member · Accepted solution]

Hi Chowdary:

     I am sorry, I do not have operation manual, I created clouldshare environment base on your attach http://rbranger.wordpress.com/2013/04/06/using-hana-on-cloudshare-part-1-setup-connectivity/#comment... address, so I think that your trouble is browser issue, could you try other browser to login clouldshare environment (https://use.cloudshare.com/Pro/Login.mvc), and the system maybe ask you install add-on of browser again for new browser. Besides, if you meet SSL security warning, you can choose trust it and continue.

If you want to access your SAP HANA Studio server of cloudshare environment, please choose "view VM". please refer to figure as attached.

If you have trouble to access SAP HANA Studio server of cloudshare, please create screenshot, if possible.

Regards

Jerry.

[Former Member · Accepted solution]

Thanks alot jerry. i figured it out. and the way you posted is right..

[Former Member · Accepted solution]

Hi Jerry,

I am able to use SAP HANA Studio on cloud share. I want to use SAP HANA Studio installed on my system to access HANA DB. I followed the steps described in the blog you had mentioned.

Facing the issue mentioned in the blog.i can find the instance is in yellow state and some services are not started. you can find the screen shot attached.

[vivekbhoj · Accepted solution]

Hi satish,

You can check :

Note 1639568 - SAP HANA studio displays system status as yellow

or these threads :

http://scn.sap.com/message/10994667#10994667

http://scn.sap.com/thread/3204682

[Former Member · Accepted solution]

Hi Vivek,

i am not able to figure it out exact problem, can you detail me in simple steps. what exactly it may be.

i am not able to follow the links you mentioned.

since i am using cloudshare. instance number 00, system:HDB and the link provided by cloudshare to configure as mentioned in blog mentioned in previous message.

and the username and pasword , i am able to figure it out from hana studio mentioned in cloudshare.

In the blog, they mentioned using information design tool.

Please help me how to configure odbc data source for hana studio in windows 7.

[Former Member · Accepted solution]

Hi Chowdary,

I checked your screenshot, the sapstartsrv service did not start in landscape, so if you need use sap then you need to start this service by manually.

please refer to http://scn.sap.com/thread/272552 to check how to start and stop this service.

hope this can help you resolve your issue.

Regards

Jerry

[Former Member · Accepted solution]

Hi jerry,

I am  new to SAP HANA and i am not aware where to handle sapstartsrv. can you describe in detail, where can i handle this service.

I am using 30 days trail version of  HANA cloud. HANA server was installed on linux, and i hardly have knowledge  how to handle those services on linux.

please find the attachment of the system provide by cloud.

[Former Member · Accepted solution]

Hi Chowdary,

Please check below screenshot to find sapstartsrv and start it.

You also can use command to start sap service, please refer to below link.

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/b3/903925c34a45e28a2861b59c3c5623/content.htm

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/1d6feeff6e0d46e10000000a155369/content.htm

Regards,

Jerry

[Former Member · Accepted solution]

Can we start hana server from hana client as mentioned in below link

http://scn.sap.com/message/13821465

By default, username and password are mentioned as  hdbadm password HANAabcd1234

Is this same for the Hana Cloud server to. if so i can handle it and start sapstartsrv from client itself.

[Former Member · Accepted solution]

Hi chowdary,

I am not sure whether you only can start this server via HAHA studio, if you want to try on studio, you can do it.

As my knowledge, usually, the similar issue operate on HAHA server side directly.

Regards

Jerry.

[Former Member · Accepted solution]

My system status can not be determined.

Please help me in solving issue. before i am at least find my system in yellow status. please find the attachment for the status

[Former Member · Accepted solution]

Please suggest, how can resolve this issue.

Error:  Connection and Backup Permission check has encountered a problem.

[vivekbhoj · Accepted solution]

Hi Satish,

Ensure that hosts entry is maintained in the hosts file :

C:\WINDOWS\system32\drivers\etc\hosts

You can refer to below threads for the same issue :

http://scn.sap.com/message/14160059

http://scn.sap.com/community/hana-in-memory/blog/2012/08/02/having-trouble-accessing-your-hana-box-t...

http://scn.sap.com/thread/2117543

http://scn.sap.com/thread/3381963

[Former Member · Accepted solution]

Following is the error after modifying the file hdbstudio.ini which was mentioned in one of the link.

please find the attachment for the image stuido.ini.jpeg

when i replaced the file. i am able to open the studio..

and i had gone through the link and found out some points

• PING to the system from a command promt. Response allright!
• Use Telnet to check if port 3<instance>15 (30015 for instance 00) is open, and of course you'll find it to be open.
• Create an ODBC System DSN to the HANA system and see if this is connectable. No surprise that it will be working!
• Open your favorite browser to check if port 5<instance>13 (for HTTP) or 5<instance>14 (for HTTPS) is open: (50013 and 50014 for instance 00)
  http://<sap_hana_host>:50013/?wsdl or https://<sap_hana_host>:50014/?wsdl.
  This will give you a repsonse, in fact an XML schema.

1. to which address i should ping and check..

2. telnet is not working on my system. is there any option to check whether the ports are open or not.

3. i had already created odbc. and how can i check the connection status.

4. i can see the xml format for the 4th point mentioned

[Former Member · Accepted solution]

Solution for the error: backup permission check has encountered problem.

Need to get the license from SAP with id S* or P* user id you are allocated with. and you will receive a text file and install it in the system by right clicking the system and choose properties.

in the popup, choose license and load the text file. so you will be given a month time if you are new developer with trail version.

further in detail, please go through following link

http://scn.sap.com/docs/DOC-31036

Now i see my system with yellow status

now how can i change the status to green.

[Former Member · Accepted solution]

Hi Chowdary,

Could you check error log for detail information, you can find error log in system disk. please check follow figure.

Maybe some configuration is wrong for null point exception.

Regards,

Jerry