SQL30082N Security processing failed with reason "15"

[Former Member]

While tring to connect to the local database with R3trans it fails with the below error

4 ETW000 [dev trc ,00000] *** ERROR in DB6Connect[dbdb6.c, 1463] CON = 0 (BEGIN)

4 ETW000 33 0.117742

4 ETW000 [dev trc ,00000] &+ DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N Security processing failed with reason "15" ("PROCESSIN

4 ETW000 49 0.117791

4 ETW000 [dev trc ,00000] &+ G FAILURE"). SQLSTATE=08001

What could be the reason?

[Former Member]

Hi

1)Can you check if diag log contains any relevent information.

2)Seems that your password is expired or you don't have required priviliges for connection. You need to check the user if it has connect privileges.

Thanks

Sandeep

[Former Member]

Hi,

you should probably create user passwords once more in another hashing method.

I solved my issue by following the solution in this link

SQL30082N Security processing failed with reason 15 PROCESSING FAILURE

[former_member640873]

Hello ETSG Team,

The encrypted file that stored the <sid>adm/<sap<sid> password is probably out of sync with the OS passwords, please run the following for each of the <sid>adm/<sap<sid> users:

<logon as <sid>adm>

dscdb6up <sid>adm <password>

dscdb6up sap<sid> <password>

Refer to OSS Note 582875 for more information.

Regards,

[Former Member]

Hi,

changed the password ,but again the same error "SQL30082N Security processing failed with reason "15" ("PROCESSIN"...

Rgds,

[Former Member]

Hi,

the error code is described in Information Center and it means:

15 (PROCESSING FAILURE)

Security processing at the server failed

I would expect that you either have some problems with file permissions or that your password service process does not work by some reason. I would suggest shutdown the instance and do an instance update as root:

db2iupdt db2<sid>

After that you should be able to connect. If not, you should also check your parameter settings of the instance.

Regards

Ralph

[former_member640873]

Hello,

Have you tried using that password to connect to the database from DB2 side? i.e.

As db2<sid>,

db2 connect to <sid> user db2<sid> using <password of db2<sid>>

and

db2 connect to <sid> user sap<sid> using <password of sap<sid>>

Regards,

[Former Member]

Hi Beck Tang,

I am also facing the same issue .While I am trying to run below commands I am getting following error :

> db2 connect to I64 user db2i64 using <******>

SQL30082N Security processing failed with reason "15" ("PROCESSING FAILURE").

SQLSTATE=08001

> db2 connect to I64 user sapi64 using <******>

SQL30082N Security processing failed with reason "15" ("PROCESSING FAILURE").

SQLSTATE=08001

Could you please let me know what to check now .

Thanks,

Arun

[former_member182505]

hi

please

Refer to OSS Note 582875 for more information

and check the back tang post.

thanks

sadiq

[Frank-Martin]

Hi,

try if an OS logon with the given user/pwd works ( do not use "su - " ) .

If this works the DB2 executables under the sqllib directory may not have correct permissions . Try to run db2iupdt on the given DB2 instance as root user.

Regards

Frank