IBM Support

"KFWITM400E with a consequent SQL30082N reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 in TEPS logs

Question & Answer


Question

"KFWITM400E A connection to the Tivoli Enterprise Monitoring Server could not be established" with a consequent SQL30082N Attempt to establish connection failed with security reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 in TEPS logs SQL30082N Attempt to establish connection failed with security reason "19" ("USERID DISABLED or RESTRICTED"). SQLSTATE=08001 seen in TEPS logs after a failed login message to the TEP: "KFWITM400E A connection to the Tivoli Enterprise Monitoring Server could not be established"

Answer

The first two things to check while debugging this issue are:

- try to use the db2admin account to login
- check that the user is not disabled and the password is not expired.

If the above checks are ok, the issue is caused by a problem with OS User Rights:


If you are on a Windows box:
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. (default: DB2ADMNS, DB2USERS)
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"

In case the button to add a group to the user right is not clickable, there could be a domain policy that set this user right. If this is the case, contact your Windows System Administrator.

[{"Product":{"code":"SSZ8F3","label":"IBM Tivoli Monitoring V6"},"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Component":"ITM Tivoli Enterprise Portal Server V6","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":""}]

Document Information

Modified date:
17 June 2018

UID

swg21299263