3789493 - Consuming SAP Datasphere via ODBC fails with error "414 user is forced to change password"

• ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;414 user is forced to change password: alter password required for user
• Connection attempt from an ODBC client (for example, MS Excel, Power BI) fails when using a newly generated database user password
• The system-generated password includes multiple special characters (for example: [] {} () , ? * = ! @)

• SAP Datasphere

1. In Space Management, open the target space, go to Database Access, and request a new password for the database user.
2. Configure an ODBC connection using the SAP HANA ODBC driver.
3. Test or establish the ODBC connection and observe error 414 indicating the user is forced to change the password.

• The password policy requires a password change on first login for the database user. ODBC clients cannot complete an interactive first-login password change, resulting in error 414.

1. Disable password lifetime for the user

   • In Space Management → Database Access → open the user → disable "Enable Password Lifetime". Then request a new password and the force change flag will no longer be set.

2. Change the password manually via Database Explorer with SQL:
   ALTER USER "SPACE_TECHNAME#<USER_NAME>" PASSWORD "<NEW_PASSWORD>"
3. Adjust the password policy globally.
   • In Configuration → Security → Password Policy → set "Force First Password Change" to disabled. 
   • This applies to all database users going forward.

• refer to: 3734352 - Datasphere HANA ODBC Test Connection Error
• refer to: 3626156 - CI-DS task fails with: General error;414 user is forced to change password
• refer to: 3381797 - ODBC connection error to Datasphere's database
• refer to: 2891554 - How to create a Support User in SAP Datasphere

odbc, error 414, user is forced to change password, alter password required for user, hana odbc, hdbodbc, first login, force first password change, password lifetime, database access, multitenant, tls/ssl, database explorer, alter user, excel , KBA , DS-SM , Space Management , Known Error