How to Define Role to different Server Nodes in Multi Node HANA System

The standard SAP recommended Node role would be as follows:

In the above screen shot we have three nodes in which the first node has been set as Master node for Index and Name server.

How to Trouble Shoot Statistic server migration Failed

Run the following SQL to determine the time it failed at

select
        value
from

_SYS_STATISTICS.STATISTICS_PROPERTIES
where key = 'internal.installation.state'

This will return the time that the switch failed at

How to Secure the Communication between SAP HANA Studio and SAP HANA Server through SSL

This blog shows you, how to secure the communication between HANA Server and HANA Studio through SSL. It is highly recommended when there are lot of sensitive data handled in the system, which you want to secure from the middle-man attacks. There could be multiple documents available in SCN on this topic, but here I wants to show my experience on setting this up, in short time.

Pre-requisites:

• HANA Server is installed and running
• HANA studio is installed in the local system
• Access to the HANA server
• Putty / WinSCP tools 

HANA Server and client without SSL configured: