2990015 - HANA Basic How-To Series - HANA and SSL - establishing a secured ODBC/JDBC connection using HANA Studio is unable to find valid certificate path to requested target

This KBA is part of the HANA Basic How-To Series and will talk about a few common issues when connecting HANA Studio via SSL to the HANA Database. HANA Studio is a good example to see if secured connections to the HANA Database will work properly. This can be used as basis to say ABAP, or HANA 2 Cockpit connections will work in a secured connection as well.

When registering a HANA System within HANA Studio is not working you can have a look into the Log file.

It can be opened by the Menu "Help" -> "About HANA Studio" -> "Installation Details" -> Tab: "Configuration" , then "View Error Log"

Sample Problem: The HANA system shows yellow status in the Systems View of the SAP HANA Studio with error 'sapstartsrv' service not started / unable to find valid certificate path to requested target

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

• SAP HANA 1.0 
• SAP HANA 2.0 

encrypt , KBA , HAN-DB-SEC , SAP HANA Security & User Management , How To