We are copying a database using File-Based data backup taken from another database.
When we are connecting to target DB after recovery it shows the invalid user name or password.
We have tried to update the source system password in Properties of the target DB but still it does not work.
It is a very normal behavior in HANA Studio while saving the target SYSTEM user password.
Please do as following:
You must change the source SYSTEM user password after system copy the password of SYSTEM user.
Now it is must to log off and log on again with source system SYSTEM user password after recovery in HANA studio.