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