Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    268

    Unanswered: DB2 Access to Domain Users

    Linux 5.2 DB2 V9.5 FP 6a.

    We are trying to give our developers access to DB2 on a Linux server but so no success. Our Linux admin created a local group in Linux server and add those developers' domain accounts into it. Then, I pulled the local group into DB2 database (User and Group Objects --> DB Groups) and give "Connect to Database" access but not successful.

    I even stop/start DB2 but no luck.

    Domain group name looks like "SOMEDOMAIN\domain^users" on the linux server. It is Windows controlled domain.

    Error: SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001.



    Is there any way to accomplish this ?.

    Thanks.
    Last edited by mdx34; 01-14-11 at 15:15.

  2. #2
    Join Date
    Oct 2009
    Posts
    2
    Can you confirm the users are able to login to the linux server using ssh?

    Are you using Samba to integrate to Active Directory?

  3. #3
    Join Date
    Oct 2004
    Posts
    268
    Thank you for your reply. Yes, they are able to logon to Linux server.

    With

    if [ -f /home/db2inst1/sqllib/db2profile ]; then
    . /home/db2inst1/sqllib/db2profile
    fi


    in their profile, they are able to run some DB2 commands but can not connect to the database with the local group account given permissions to connect to the database.

    No we are not using Samba..............Thanks

    Calvin.

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    By default DB2 enumerates the users' group on the system where the users are defined, that is, in the AD in your case.

    Try setting the registry variable DB2_GRP_LOOKUP to LOCAL.

  5. #5
    Join Date
    Oct 2004
    Posts
    268
    Thanks...........I set the DB2_GRP_LOOKUP to LOCAL but no luck. I stop and restart DB2 and even reboot the server but the same error.

    SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
    PASSWORD INVALID"). SQLSTATE=08001

Posting Permissions

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