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

[Former Member]

Hi Team,

while doing system import I stuck at IMPORTABAP phase, I verified logs as per log info the issue with user name and password .

updated user and password in dscdb6.conf file but till I am getting same issue.

SWPM-SWPM10SP05

R3load -testconnect

sapparam: sapargv(argc, argv) has not been called!

sapparam(1c): No Profile used.

sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline

R3load: START OF LOG: 20160502122949

R3load: sccsid @(#) $Id: //bas/721_REL/src/R3ld/R3load/R3ldmain.c#10 $ SAP

R3load: version R7.20/V1.6 [UNICODE]

Compiled May 24 2014 05:59:08

R3load -testconnect

DbSl Trace: DbSlConnect to 'PIS' as 'sappis' failed

(DB) ERROR: db_connect rc = 256

DbSl Trace: DbSlConnect to 'PIS' as 'sappis' failed

(DB) ERROR: DbSlErrorMsg rc = 29

R3load: job finished with 1 error(s)

R3load: END OF LOG: 20160502122949

TRANS.LOG

4 ETW000  [	dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1835] CON = 0 (BEGIN)	10  0.672729
4 ETW000  [	dev trc,00000]  &+	DbSlConnectDB6( SQLConnect 😞 [IBM][CLI Driver] SQL30082N  Security processing failed with reason "24" ("USERNAME
4 ETW000	14  0.672743
4 ETW000  [	dev trc,00000]  &+	AND/OR PASSWORD INVALID").  SQLSTATE=08001
4 ETW000	11  0.672754
4 ETW000  [	dev trc,00000]  &+
4 ETW000	10  0.672764
4 ETW000  [	dev trc,00000]  &+
4 ETW000	11  0.672775
4 ETW000  [	dev trc,00000]  &+
4 ETW000	10  0.672785
4 ETW000  [	dev trc,00000]  *** ERROR in DB6Connect[dbdb6.c, 1835] (END)	8  0.672793
4 ETW000  [dbdb6.c	,00000]  *** ERROR => DbSlConnect to 'PIS' as 'sappis' failed	45  0.672838
2EETW169 no connect possible: "DBMS = DB6	--- DB2DBDFT = 'PIS'"

Please guide me.

Thanks,

Naveen

[hugo_amo]

Hi Naveen,

Try the following:

1. Logon directly as the user sap<sid> at OS level. Does this succeed?

2. Connect to the database as following:

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

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

Do either of these fail ?

If the password fails then you will need to update it:

1. If OS logon fails perform:

   - passwd sap<sid> <password>

2. Then perform the following to update the dscdb6.conf password file:

   logon as <sid>adm

   dscdb6up sap<sid> <password>

If only the connect to the database fails then only step 2 is needed.

Regards,

Hugo

[former_member188883]

Hi Naveen,

Please check some troubleshooting guidelines as mentioned in the link below

https://www-304.ibm.com/support/docview.wss?uid=swg21416382

Regards,

Deepak Kori