ADD SAP HANA Database connection to Solution manager 7.2 | Techrelam

 ADD SAP HANA Database connection to Solution manager.

Using SAP saphostagent / sapdbctrl for NewDB connection establish between solman7.2 and HANA DB.

 If you want to use the SAP HANA database connect without a password, the following below prerequisites:

1. We need to monitor the hana database you require a database user with the monitoring role.
You can create a database user with the NewDB studio. Connect as the SYSTEM user and execute the following SQL commands:

CREATE USER <username> PASSWORD x<password>x
GRANT MONITORING TO <SID>DBCTRL

 
Then logon to the NewDB studio under the username <username> and execute the following command:

ALTER USER <Username> PASSWORD <password>

2. As the OS user <sid>adm, you must provide the user key <SID>SAPDBCTRL in hdbuserstore on the database server. You can check the existence of the user key with the following command:

hdbuserstore LIST <SID>SAPDBCTRL

If the user key does not exist, you can create it as follows:

hdbuserstore SET <SID>SAPDBCTRL <dbhost>:<port> <Username> <password>

The tool hdbuserstore is installed under the following paths:

/usr/sap/hdbclient or
/usr/sap/<SID>/hdbclient

3. To check whether the sapdbctrl queries without passwords work, execute the following command as OS user <sid>:
 

/usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname <SID> -dbtype hdb


If sapdbctrl responds with the following error text:
ERROR: Database user authentication failed: SQLDriverConnect: Connect with userkey failed!
then you must check the connect data in hdbuserstore again.