Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    67

    Unanswered: SQL30082N Security processing failed with reason "19"

    DB2 9.1.2
    Windows Server 2003

    When I try to connect to a database, I receive this message:

    db2 connect to xxxx user dbi
    SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001

    I can make Windows logon with that user.

    With another user I can connect to that database.

    db2diag.log shows this messages:

    2009-09-07-17.28.36.018000-240 I40131393F512 LEVEL: Error
    PID : 3348 TID : 4984 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-265
    FUNCTION: DB2 UDB, oper system services, sqlo_validate_pwd, probe:1000
    MESSAGE : Error Logon Type not granted for account:
    DATA #1 : Hexdump, 31 bytes
    0x000000015C2C8300 : 6462 6900 0000 0000 0000 0000 0000 0000 dbi.............
    0x000000015C2C8310 : 0000 0000 0000 0000 0000 0000 0000 00 ...............

    2009-09-07-17.28.36.018000-240 I40131907F276 LEVEL: Warning
    PID : 3348 TID : 4984
    FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
    DATA #1 : String, 62 bytes
    Password validation for user dbi failed with rc = -2146500483


    2009-09-07-17.28.48.300000-240 I40132185F513 LEVEL: Error
    PID : 3348 TID : 4684 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    APPHDL : 0-1925
    FUNCTION: DB2 UDB, oper system services, sqlo_validate_pwd, probe:1000
    MESSAGE : Error Logon Type not granted for account:
    DATA #1 : Hexdump, 31 bytes
    0x000000016DE08300 : 6462 6900 0000 0000 0000 0000 0000 0000 dbi.............
    0x000000016DE08310 : 0000 0000 0000 0000 0000 0000 0000 00 ...............

    2009-09-07-17.28.48.300000-240 I40132700F276 LEVEL: Warning
    PID : 3348 TID : 4684
    FUNCTION: DB2 Common, Security, Users and Groups, secLogMessage, probe:20
    DATA #1 : String, 62 bytes
    Password validation for user dbi failed with rc = -2146500483


    Thank you,

    Ferdinand

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  3. #3
    Join Date
    Nov 2004
    Posts
    67
    Solved the problem deleting this user and creating a new one with the same name. That works.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •