DB2 SQL30082N Attempt to establish connection failed with security reason "1"

junaid377 · #1 (**permalink**) 01-26-12, 13:35

I am running DB2 9.1 on redhat linux 5.1 ...

I am trying to connect to db2 but getting this error

"SQLConnect: rc=-1, SQLSTATE: 08001, Error Msg:[IBM][CLI Driver] SQL30082N Security processing failed with reason "1" ["PASSWORD EXPIRED"], SQLSTATE=08001"

THUMBNAIL ATTACHED

....when tried to change password it says not authorized to do so

The user is not a sysadm (db2inst1 ) and just has access to select from tables nothing more....

any ideas ...

ARWinner · #2 (**permalink**) 01-26-12, 13:46

How is the authentication being performed (by the OS or some other method)? How did you try to change the password?

Andy

junaid377 · #3 (**permalink**) 01-26-12, 14:06

OS and using passwd command on linux terminal

ARWinner · #4 (**permalink**) 01-26-12, 14:09

Quote:

Originally Posted by junaid377

OS and using passwd command on linux terminal

Which user are you logged in with when you issue passwd?

Andy

junaid377 · #5 (**permalink**) 01-26-12, 15:23

Ok .....

I tried to connect through HYPERION to my db2 9.1 server using username jnazir when I got the error... I then logged into that server through jnazir and entered passwd... then I got the error password expired.. I entered passwd to change passwd but it gave me that not allowed to perform this operation error

ARWinner · #6 (**permalink**) 01-26-12, 15:39

What is the exact error you are getting?

Andy

Internet Services

Web Development

Digital Marketing

Consumer Tech