SAP Knowledge Base Article - Preview

2837368 - Password restriction considerations when using external authentication with an LDAP server and client tools like DBISQL - SAP IQ

Symptom

  • SAP IQ  login IDs that are enabled to use LDAP external user authentication  may have LDAP synchronised passwords  that do not comply with SAP IQ password restrictions.

  • SAP IQ security functionality is unable to enforce SAP IQ password restrictions for LDAP passwords as they are presented in an encrypted format.

  • LDAP passwords containing restricted characters like semicolons ; can end up being stored as valid passwords in the SAP IQ system table.

  • DBISQL client connections to SAP IQ using a password containing a restricted semicolon character will fail with an invalid user ID or password error.

SQLCODE=-103

SQLSTATE=28000


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.x

Product

SAP IQ 16.1

Keywords

sybase, failure, semi-colon, 'semi colon', CR820029, CR#820029, 820029, CR820031, CR#820031, 820031, hiPAM, requires, special, characters, gui, connect, window, surrounded, defect, ODBC, DSN , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.