If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > SQL30082N Security processing failed with reason "19"

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-07-09, 18:15
CCMF CCMF is offline
Registered User
 
Join Date: Nov 2004
Posts: 16
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
Reply With Quote
  #2 (permalink)  
Old 09-07-09, 19:40
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Reply With Quote
  #3 (permalink)  
Old 09-17-09, 18:22
CCMF CCMF is offline
Registered User
 
Join Date: Nov 2004
Posts: 16
Solved the problem deleting this user and creating a new one with the same name. That works.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On