美文网首页
ibm_db链接DB2 登录报错:failed with rea

ibm_db链接DB2 登录报错:failed with rea

作者: 万事皆成 | 来源:发表于2019-05-14 08:43 被阅读0次

之前的账号被锁,解锁后重置密码
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").

相关文章

网友评论

      本文标题:ibm_db链接DB2 登录报错:failed with rea

      本文链接:https://www.haomeiwen.com/subject/wjnraqtx.html