dbanalyzer ERROR 25: SQLDBC error -4008, POS(1) Unknown user name/password combination (SQL state "28000").

[Former Member]

Hello Gurus,

we have a unusual problem with our MaxDB 7.9.8.25

We want to check the parameter like discribed in note 1111426, but dbanalyzer throws the following error.

tttadm >/sapdb/TTT/db/bin/dbanalyzer -d TTT -u superdba,****** -f dbanalyzer_InstanceParameterCheck.cfg -o /tmp -i -c 1 -t 1,1
SAP MaxDB Database Analyzer, The Performance Analysis Tool, Version 7.9.08.25
Copyright 2000-2014 by SAP AG


ERROR 25: SQLDBC error -4008, POS(1) Unknown user name/password combination (SQL state "28000").

But with dbmcli we can connect with the same user.

tttadm >  dbmcli -d TTT -u superdba,******
dbmcli on KBP>

Has anyone a suggestion?!

[thorsten_zielke · Accepted solution]

Have you tried, if you can actually do SQL with that user? Maybe there is a problem with the SQL authorization?

Does the following work for you?

>sqlcli -d tz79 -u dba,dba select * from dual

| DUMMY |

| ----- |

| a   

1 row selected (1318 usec)

dbmcli -d tz79 -u dba,dba sql_execute select * from dual

OK

END 'a'

[Former Member · Accepted solution]

I set a new password with user_put and dbmcli. That works for me. Thanks.

regards

Chris

[wei_henning · Accepted solution]

I had the same Problem. Worked for me as well. Thanks!

[Nik3 · Accepted solution]

Same here on 7.9.08.35 and now working again Thanks!

I've had the error after having uninstalled "Legacy" MaxDB components after MaxDB upgrade (7.7->7.9)