之前的账号被锁,解锁后重置密码
Windows7 Python3.7 环境下,使用 imb_db 链接 DB2 登录报错
使用 DB2_Operator.exe 登录正常
SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID").
SQLSTATE=08001
SQLCODE=-30082
<strong>24 (USERNAME AND/OR PASSWORD INVALID)
The username specified, password specified, or both, are
invalid. Some specific causes are:
1. If you have recently changed permissions on DB2 critical
files such as db2ckpw or moved to a new Fixpak, the db2iupdt
command which updates the instance might not have been run.
2. The username being used might be in an invalid format. For
example, on UNIX and Linux platforms, usernames must be all
be lowercase.
3. An error might have been made in specifying the catalog
information. For example, the correct authentication type
might not have been specified or, if applicable, the remote
server might not have been cataloged on the local system.</strong>
原因:
原来程序用把用户和密码写死了,导致账户密码错误
反思:非常低级的问题被我搞复杂了,花了一个小时才解决
"SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID")" when using Cognos Connection
【已解决】SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID").








网友评论