Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

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

    Hi,

    I am using db2 8.1 fixpak 4 on AIX 5.1. We had a problem with the db2 instance user because of too many unsuccessful logins. The user was locked. Now when i had the password reset on AIX. I am able to login to the box with db2 user, but i am getting the error when i try to connect to the existing database.
    SQL30082N Attempt to establish connection failed with security reason "1"
    Can anyone suggest any remedy on this.

    The message reference for reason code 1 says:

    1 (PASSWORD EXPIRED)
    The password specified in the request has expired.

    Please let me know ASAP.

    Cheers,
    Prashant
    Prashant

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Exclamation Automatic password change

    1. Please get the password for user db2inst1 reset again.

    2. Then log on the AIX machine (the shell) - not! DB2

    3. Change your password (you will be prompted to do this)

    4. Exit the shell.

    5. Log on to db2 (application or otherwise)

    The shell usually demands a immediate change of password
    after a reset. DB2 inherits password authentication from the
    shell. I'm guessing it's a clash of these two processes that's
    causing you trouble. Try the above and let me know if you're
    in the clear.

    BOW
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186

    Re: Automatic password change

    That was great!! Thank's a lot!!!
    It works.

    cheers!!

    Originally posted by Tank
    1. Please get the password for user db2inst1 reset again.

    2. Then log on the AIX machine (the shell) - not! DB2

    3. Change your password (you will be prompted to do this)

    4. Exit the shell.

    5. Log on to db2 (application or otherwise)

    The shell usually demands a immediate change of password
    after a reset. DB2 inherits password authentication from the
    shell. I'm guessing it's a clash of these two processes that's
    causing you trouble. Try the above and let me know if you're
    in the clear.

    BOW
    Prashant

Posting Permissions

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