SQL30082N with Reason "19"

[edmund...@gmail.com]

I have a DB pm AIX.

After I log on the server using SSH,
I try to connect to the DB using account1.

When i type "db2 connect to <db name>" with account1,
it can connect successfully.

After that, when i type "db2 connect to <db name> user account1 using <passwd>",
there is an error.

SQL30082N Attempt to establish connection failed with security reason "19"
("USERID DISABLED or RESTRICTED"). SQLSTATE=08001

The DB I want to connect on both cases are the same. And I haved tried to use account1 to logon the server using SSH, it works.

then, how to solve the problem? thanks...

[edmund...@gmail.com]

the problem is solved by giving login permission to user.

[ganesh...@in.ibm.com]

Hi,

If you are on a WIN XP:

1) Goto windows "Control Panel"
2) Double Click on - "Administrative Tools"
3) Double Click on - "Local Security Policy"
4) In the Left Panel Tree, Select : "Local Polocies" --> "User Rights Assignment"
5) Double click on "Access this computer from the network" and add your user/group.
6) Make sure that you dont have this user under : "Deny access to this computer from the network"

And this will allow you to resolve your problem- "SQL30082N Security processing failed with reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001"

Thanks and Regards,
GANESH GOSAVI
IBM, India Software Labs, Pune