I have installed DB2 9 Enterprise Edition on my laptop (Windows xp prof.
ed.). But when I try to connect to any of my local databases I get this
error:
SQL30082N Security processing failed with reason "19" ("USERID DISABLED or
RESTRICTED"). SQLSTATE=08001
I am quite certain that this user is valid, I have used it to log on to the
pc. The properties of the user also looks fine -password never expires, and
the disabled checkbox is NOT checked. And it's the same user the db2 service
uses. I have further checked that the user is member of these groups:
Administrators, DB2ADMNS, DB2SYADM (which is the group I use as
SYSADM_GROUP). So I will not accept that this user has any restrictions as
to access db2 :-)
If I logon without applying the username and password from a Command
window, I can connect : 'db2 connect to sample' works fine. But if I connect
with ' db2 connect to sample user db2admin using xxxxxx' I get the error
message.
I can connect to remote databases ( all on version 8) without problems. It's
the local databases that gives med the headache.....
I suspect there have been changes in security policy in version 9, but I
cannot find anything in the documentation.
Anyone have the solution to this?
Regards
Odd B Andersen
ErgoGroup AS, Oslo, Norway