SAP Hana agent not connecting with user other than SYSTEM
Albook 120000625S Visits (4564)
After having installed the SAP HANA agent, you must configure it by providing mandatory information:
- Server Name / IP address of the SAP HANA server
The Hana DB User is the account used by the agent to connect the SAP HANA DB.
For example, in a case I recently investigated, the agent was able to connect only using the SYSTEM account.
After a while the ks7client process also closed and was restarted by ks7agent.
This happened repeatedly with the agent never able to complete connection to the SAP HANA DB.
1. Go to the directory where HanaDB Client is installed (eg: C:\Program File
The execution of the hdbsql client with command \c basically performs a connection to the target SAP HANA DB.
It showed us where the problem was because the server asked to change the password again.
In an interactive shell you can do it, but of course agent cannot cope with that request and so fails to connect.
This behavior occurs when the used is defined with "Force Password Change on next logon" after a password reset.
I talked with db admin asking to reset again the password and remove this flag.
After this, agent has been reconfigured to match the new password and then it was able to connect and collect data from
Hope it helps.
Subscribe and follow us for all the latest information directly on your social feeds: