Symptom
SQL5154N error occurs when attempting to change DB2 parameters TRUST_ALLCLNTS and TRUST_CLNTAUTH as follows:
- UPDATE DBM CFG USING TRUST_ALLCLNTS NO
SQL5154N The requested combination of configuration values for
"authentication" and "trust_allclnts" is not allowed. Reason code = "1".
- UPDATE DBM CFG USING TRUST_CLNTAUTH SERVER
SQL5154N The requested combination of configuration values for
"authentication" and "trust_clntauth" is not allowed. Reason code = "1".
- The error message displayed is "SQL5154N The requested combination of configuration values for 'authentication' and 'trust_allclnts' is not allowed. Reason code = '1'." and "SQL5154N The requested combination of configuration values for 'authentication' and 'trust_clntauth' is not allowed. Reason code = '1'."
Read more...
Environment
- SAP on IBM DB2 for Linux, UNIX, and Windows
- Db2 version older than 11.5 Fix Pack 9
Product
SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5
Keywords
TRUST_ALLCLNTS, TRUST_CLNTAUTH, SQL5154N, AUTHENTICATION , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , 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.