Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2004
    Posts
    58

    Question Unanswered: SQL30082N Attempt to establish connection failed with security reason "19"

    I am able to connect user newuser1 to the database without any problems.

    > db2 connect to Feddb

    Database Connection Information

    Database server = DB2/6000 8.2.2
    SQL authorization ID = NEWUSER1
    Local database alias = FEDDB

    But when I used to following command I got the error below:

    > db2 connect to FEDDB user newuser1 using pass123

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


    Server Connection Authentication (SRVCON_AUTH) = NOT_SPECIFIED
    Database manager authentication (AUTHENTICATION) = SERVER
    Cataloging allowed without authority (CATALOG_NOAUTH) = NO
    Trust all clients (TRUST_ALLCLNTS) = YES
    Trusted client authentication (TRUST_CLNTAUTH) = CLIENT
    Bypass federated authentication (FED_NOAUTH) = NO


    Please advise. Any suggestions would be greatly appreciated. Thank you!

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Hold on a sec. On one line you are saying that you can connect fine. on another youa re saying that you can't. Are you having a case of a split personality?

    can you clarify your question?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Apr 2004
    Posts
    58
    When I logged on as Instance owner and issued command below, I got error.

    db2 connect to FEDDB user newuser1 using pass123

    When I 'su' to the user newuser1 on AIX, I was able to connect database without problem.

    > db2 connect to Feddb

    Database Connection Information

    Database server = DB2/6000 8.2.2
    SQL authorization ID = NEWUSER1
    Local database alias = FEDDB

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    It sounds like you are getting this error when you are trying to connect from a remote server. Check that user on that server. That id is most likely disabled there.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  5. #5
    Join Date
    Apr 2004
    Posts
    58
    I'll check. Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •