-24950,ERR_USRFAIL: User authorization failed

[Former Member]

Hello,

When try to login to livecache:

dbmcli -d LCA -u control,Scmbasis0$

It gives error:

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

-24950,ERR_USRFAIL: User authorization failed

But if tried to execute DB59 test is successful.( control and SAPLCA has same password as Scmbasis0$ which is maintained in integration data )

/n/sapapo/om03 : test is ok:

sdbregview -l

SAP Utilities e:/sapdb/programs 7.6.00.29 64 bit valid

DB Analyzer e:/sapdb/programs 7.6.00.29 64 bit valid

Server Utilities e:/sapdb/programs 7.6.00.29 64 bit valid

APO LC APPS f:/sapdb/liv/db/sap 5.00.004 64 bit valid

APO LC APPS f:/sapdb/lea/db/sap 5.00.007 64 bit valid

APO LC APPS e:/sapdb/lca/db/sap 5.00.007 64 bit valid

APO COM f:/sapdb/lcb/db/sap invalid

APO LC APPS f:/sapdb/lcq/db/sap 5.00.007 64 bit valid

APO COM f:/sapdb/ich/db/sap invalid

Base e:/sapdb/programs 7.6.00.29 64 bit valid

Redist Python e:/sapdb/programs 7.6.00.29 64 bit valid

JDBC e:/sapdb/programs 7.6.00.24 valid

Messages e:/sapdb/programs MSG 0.3347 valid

ODBC e:/sapdb/programs 7.6.00.29 64 bit valid

Database Kernel f:/sapdb/lea/db 7.6.00.29 64 bit valid

Database Kernel f:/sapdb/lcb/db 7.6.00.22 64 bit invalid

Database Kernel !f:/sapdb/lcb/db 7.6.0.22 invalid

Database Kernel f:/sapdb/liv/db 7.6.00.22 64 bit valid

Database Kernel e:/sapdb/lca/db 7.6.00.29 64 bit valid

Database Kernel f:/sapdb/lcq/db 7.6.00.29 64 bit valid

Database Kernel !f:/sapdb/lcq/db 7.6.0.29 invalid

Database Kernel f:/sapdb/ich/db 7.6.00.22 64 bit invalid

Database Kernel #f:/sapdb/lcb/db 7.6.0.22 invalid

Loader e:/sapdb/programs 7.6.00.29 64 bit valid

SQLDBC e:/sapdb/programs 7.6.00.29 64 bit valid

SQLDBC 7600 e:/sapdb/programs 7.6.00.29 64 bit valid

Regards,

Prashant

[Former Member]

Hello Ashwath ,Thushar,

Yes Password was wrong.Thanks.

Regards,

Prashant

[Former Member]

Hello Ashwath ,

After all I was informed that password was wrong.

Any way thanks for information you have given.

Regards,

Prashant

[Former Member]

Hi

looks like you are giving a wrong password for control. You can also try to login with user superdba .

Thanks

Prince Jose

[Former Member]

Hello,

Another info:

C:\Documents and Settings\scmadm.BOMW047A.003>dbmcli -s dbm_version

OK

VERSION = 7.6.00

BUILD = DBMServer 7.6.00 Build 029-123-130-265

OS = WIN64

INSTROOT = e:\sapdb\lca\db

LOGON = True

CODE = ASCII

SWAP = full

UNICODE = (unknown)

INSTANCE = (unknown)

SYSNAME = Windows Server 2003 family

System details:

SCM 5.0

Regards,

Prashant.

[Former Member]

Hi Prashant,

are you sure that the password is the same as that maintained in the liveCache integration data?

If yes, try renaming the <SID>.upc and dbm.upc files, then logon to the liveCache by dbmcli, and reload the system tables. Tell us if this works.

Thanks,

Ashwath