SAP Knowledge Base Article - Preview

2341399 - Failed to log on to specific secondary node in mpx environment.


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.



  • SAP IQ 16.0
  • SAP IQ 15.4
  • SAP Sybase IQ 15.3
  • Multiplex Environment


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


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.