Question Re: -24950,ERR_USRFAIL: User authorization failed in Technology Q&A

-24950,ERR_USRFAIL: User authorization failed

Former Member — Mon, 12 Oct 2015 02:59:44 GMT

Hi everyone

I have SAP Solution Manager 7.1 On Linux suse 11 and MaxDB 7.8 with SID ZZZ. The password of dba user SAPZZZ was changed.

The old password was for example'XxHh$115' (with special caracter $) and the new password is 'XxSYy2015'.

I change the password in Database studio following the instructions of the sap notes:

25591 - Password change for DBM and DBA users

39439 - XUSER entries for SAP MaxDB

The change of the password was succesfully.

I obtain an error in the transactioN DB13 and using dbmcli command:

dbmcli: hostname_xx:ssmadm 69> dbmcli -d ZZZ -u SAPZZZ,XxSYy2015

Error! Connection failed to node (local) for database ZZZ:

-24950,ERR_USRFAIL: User authorization failed

In DB13: Name and Server :

ZZZ - hostname_xx Function

: DBM_GETF Command

: DBAHIST DATE=20141010 Error

: DBM Error Return Code : -2 Error Message

: ERR_USRFAIL: User authorization failed

I try to change the password via dbmcli with the following command:

dbmcli -u SAPZZZ,XxHh\$115 -uk DEFAULT -us SAPZZZ,XxSYy2015 -d ZZZ -n hostname_xx

but the error is: Error! wrong username or password!

Database studio is working fine, I can to execute backups with the user SAPZZZ.

Please help us to solve it, I need schedule the database backup using the transaction DB13 but the job ended with message: -24950,ERR_USRFAIL: User authorization failed.

Thanks in advanced for your help.

Best Regards,

Osmany Martínez

Re: -24950,ERR_USRFAIL: User authorization failed

Former Member — Mon, 12 Oct 2015 07:05:50 GMT

Hi Martinez,

Have your try to check if the old password is still working.

also do check your x_server process is started. Also do verify the oss note 39439 - XUSER entries for SAP MaxDB

Do let us know the details.

Regards,

Ram

Re: -24950,ERR_USRFAIL: User authorization failed

Former Member — Mon, 12 Oct 2015 13:48:49 GMT

Hi Ram

I try to use old password (with \ before $ to scape the special caracter) and I obtain:

-24950,ERR_USRFAIL: User authorization failed

x_server is runnig.

I follow the instrution of sap note 39439 to add the XUSER entries:

xuser -U DEFAULT -u SAP<SID>,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set

I obtain the error in DB13 transaction and using dbmcli.

Regards,

Osmany

Re: -24950,ERR_USRFAIL: User authorization failed

JamesZ — Mon, 12 Oct 2015 23:33:48 GMT

Hi Osmany,

What is exact command you used to change password for SAPZZZ?

Please try log on database via superdba and reset SAPZZZ password:

ALTER PASSWORD <DBA_user> <new_password>

Best regards,

James

Re: -24950,ERR_USRFAIL: User authorization failed

Former Member — Tue, 13 Oct 2015 00:38:11 GMT

Hi James

I change the password from Database Studio using the command:

ALTER PASSWORD SAPZZZ XxSYy2015

And add the xuser entry with the following command:

xuser -U DEFAULT -u SAPZZZ,XxSYy2015 -d ZZZ -n hostname_xx -S SAPR3 -t 0 -I 0 set

I can to connect to database with user SAPZZZ in Database Studio but cannot connect with dbmcli.

Best regards,

Osmany

Re: -24950,ERR_USRFAIL: User authorization failed

JamesZ — Tue, 13 Oct 2015 00:43:03 GMT

Hi Osmany,

Please try to use os command dbmcli to change/reset password for SAPZZZ.

You need to log on database via user sapsuperdba.

Best regards,

James

Re: -24950,ERR_USRFAIL: User authorization failed

Former Member — Tue, 13 Oct 2015 03:45:59 GMT

Hi Ormany,

You can do as below:-

Connect to dbmcli -d <DB NAME> -u control,<password>

Then try below commands

sql_connect superdba,<password>

sql_connect superdba,admin

sql_execute select * from users --> This will give you list of users

ALTER PASSWORD <DBA_user> <new_password> for changing other user passwords.

And for superdba you can use below:-

ALTER PASSWORD <old password> to <new password>

Do let us know if this helps.

Regards,

Ram

Re: -24950,ERR_USRFAIL: User authorization failed

Former Member — Tue, 13 Oct 2015 03:49:24 GMT

Also as your system is solman do execute below commands per note 39439 - XUSER entries for SAP MaxDB being a dual stack,

xuser -U DEFAULT -u SAP<SID>,<password> -d <database_name> -n <database_server> -S SAPR3 -t 0 -I 0 set

for j2ee:-

xuser -U c_J2EE -u CONTROL,<password> -d <database_name> -n <database_server> -S INTERNAL set

Regards,

Ram