3791776 - Unable to logon in DBeaver with the new password generated in SAP Datasphere

After trying to use a new auto-generated password in SAP Datasphere to login in DBeaver, an error message is received: 

--------
Connection to 'xyz' cannot be established;
[10] authentication failed;
Error changing expired password.
--------

SAP Datasphere

1. Logon to SAP Datasphere;
2. Under Space Management/Database Access, request a new password;
3. Logon to DBeaver with the password generated;
4. Get the error message.

The root cause for this is that the new, auto‑generated Datasphere database user password contains special characters that DBeaver (or its JDBC/ODBC driver or connection string syntax) is not handling correctly, even though the same password works elsewhere. Datasphere database user passwords are generated according to the configured password policy, which may include length and complexity (special characters). These passwords are valid for the database user itself, however, some client tools or drivers can mishandle. 

A practical workaround is to set a simpler password (ideally without special characters) for that database user in SAP Datasphere and use that in DBeaver. You have two main options to obtain a “friendlier” password:

Option A – Manually define a new password in HANA (shorter / less complex):
The KBA 0003416999 explains how to manually set a password for a Datasphere space-level database user directly in the underlying HANA system.

Option B – Use the Datasphere CLI to reset and retrieve a new password:
If you prefer not to go through HANA directly, you can reset the DB user password via the SAP Datasphere CLI. Please check the following community blogs: 
SAP Datasphere Automation : Creating Database user in SAP Datasphere using Datasphere CLI & Python | SAP Community
@sap/datasphere-cli: Reset Database User Passwords | SAP Community
* You cannot directly control the characters in the auto-generated password here, but you can then follow Option A to replace it with a simpler one if needed.

Have a question? Ask it here and let our amazing SAP community help!

Your feedback is important to help us improve our knowledge base.

dbeaver, JDBC/ODBC, wrong password, invalid password, SAP DBTech JDBC, unable to change password , KBA , DS-SM , Space Management , HAN-DB , SAP HANA Database , Problem