Troubleshooting
Problem
When trying to connect to a database or run any Db2 commands, I'm receiving one or both of the following errors:
Symptom
SQL30082N Security processing failed with Reason Code 15
"Security processing at the server failed"
SQL30082N Security processing failed with Reason Code "19"
"USERID DISABLED or RESTRICTED"
SQL30082N Security processing failed with Reason Code 24
"USERNAME AND/OR PASSWORD INVALID "
SQL30082N Security processing failed with reason "36" ("UNEXPECTED
CLIENT ERROR"). SQLSTATE=08001
Resolving The Problem
- Use an authentication testing utility to determine whether there is a configuration issue outside of Db2. Testing utilities for Linux, AIX, and Windows are available from the following document. If the user ID is locked, contact your system administrator.
https://www.ibm.com/support/pages/node/567799 - Ensure the user ID used to connect to Db2 follows the naming rules. Reference the following documentation pages:
User, user ID and group naming rules
General naming rules - If an SQL1639N error is returned, ensure the permissions on the db2ckpw and db2chpw files are correct. Reference the following document for more information:
Database connection fails with authentication error SQL1639N - When local authentication is used, Db2 releases before 9.5 FP4 only support a limited number of password encryption algorithms. Refer to the following document for more information:
SQL30082 RC=24 or RC=15 returned when connecting to database on Server when pwd_algorithm is Crypt, MD5, SHA1, SHA256, SHA512, Blowfish - On Windows systems, ensure that the user has been granted the Access this computer from network privilege.
- Click run from the start menu, or press the Windows key + R to open the run menu
- Type secpol.msc to open the group policy editor
- Navigate to Local policies -> User rights assignments
- Double-click Access this computer from network
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmmAAE","label":"Security and Plug-Ins-\u003EAuthentication"}],"ARM Case Number":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
08 September 2022
UID
swg21416382