Symptom
Failed to log on to specific secondary node after changing password using "sp_iqpassword or alter user command".
- call sp_iqpassword ('oldpassword', 'newpassword') or
- ALTER USER test_user identified by password;
A user can only log on to coordinator and the other secondary node, but fails to log on to specific secondary node.
A user needs to sync the secondary node to solve this problem.
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 15.4
- SAP Sybase IQ 15.3
- Multiplex Environment
Product
Keywords
IQ, SYBASE, PASSWORD, sp_iqpassword, alter user, invalid user, invalid password, secondary, multiplex, sa_get_user_status, max_failed_login_attempts, RESET LOGIN POLICY, lock, unlock , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.