3453943 - Datasphere S/4HANA On-Premise Connection - Name or password is incorrect RFC_LOGON_FAILURE

Validating SAP S/4HANA On-Premise connection in Datasphere gets RFC_LOGON_FAILURE error, although the user and password are correct.

Connection "<connection_name>" couldn’t be established.

• Data flows can’t be used because of errors in the connection.
  
• Replication flows can’t be used because of errors in the connection.
  
• Remote tables can’t be used because of errors in the connection.
  
• Model Import is disabled.

Data Flows: Cause: ABAP connector(Axino) ABAP connection check FAILED: request failed: rc=1, msg="Message: Name or password is incorrect (repeat logon)Code: RFC_LOGON_FAILURE"
Please refer to SAP Note 2849542 for more information. Code:1103002
Replication Flows: Cause: ABAP connector(Axino) ABAP connection check FAILED: request failed: rc=1, msg="Message: Name or password is incorrect (repeat logon)Code: RFC_LOGON_FAILURE"
Please refer to SAP Note 2849542 for more information. Code:1103002
Remote Tables: Unable to connect remote source: Initialization of destination <destination> failed: Name or password is incorrect (repeat logon), Code: 5921, SQL State: HY000

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

SAP Datasphere

"Datasphere" "RFC_LOGON_FAILURE" , KBA , DS-DI-CON , Connections , Problem