on 09-21-2012 12:31 PM
Hi,
I´m freshman in Maxdb and I´m working with an old version (SAP DB 7.3.0.62).
When I try to start SAP instance I get the error,
*** ERROR => Connect to database failed : sqlcode=-4008 (Unknown user name/password combination)
[dbslada.c 6083]
I guess I´ll solve my problem with note 39439 but when I try to run any xuser command a new command window opens asking for a login. This window:
/SSSSSSS /A /PPPPPPP /DDDDDDDD /BBBBBBBB
/SS////// /AAA /PP////PP /DD/////DD /BB/////BB
/SS /AA AA /PP /PP /DD /DD /BB /BB
/SSSSSS /AA /AA /PPPPPPP/ /SSSSS /DD /DD /BBBBBBBB/
/////SS /AAAAAAA /PP//// ////// /DD /DD /BB/////BB
/SS /AA /AA /PP /DD /DD /BB /BB
/SSSSSSS/ /AA /AA /PP /DDDDDDDD/ /BBBBBBBB/
//////// /// /// /// ///////// /////////
/SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
/SSSSSSSS U S E R SSSSSSSS//////
/SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS//////
/////////////////////////////////////////////////
Username ==> Password ==>
I enter control or superdba users (I know password is correct because I can connect via dbmcli) but I get message USERNAME/PASSWORD ILLEGAL.
Anybody knows why I can´t execute xuser commands?
I´ll appreciate any help.
Thanks in advance,
Pablo.
Hello Natalia,
During ERP6.0 EHP8 Update using SUM tool, we get the error "Last error code set: XUSER key 'DEFAULT' does not exist or could not be identified" in SUM Phase "MOD_SELROADMAP/SELECT_ROADMAP!" (see screenshot in attachment).
Currently the SAP system running with latest MaxDB version in Windows Server 2019. Environment variables are correclty maintained in the server. Following result, we get with xuser command:
E:\sapdb\SID\db\bin>xuser -U DEFAULT list
------------------------------------------------
XUSER Entry 1
----------------
Key : DEFAULT
Username : <unspecified>
Password : <unspecified>
Dbname : <unspecified>
Nodename : <unspecified>
Sqlmode : <unspecified>
Cachelimit : -1
Timeout : -1
Isolation : -1
Any ideas are appreciated.
Thanks
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Pablo,
when you are using 7.3 xuser version, you could logon xuser programm with sapr3 user and sap password, if the default password was not changed & default key xuser entries were created correctly
before for your OS login user. Or you need to know the correct password of the default key XUSER entry.
Please follow the note 25591 when you will change the passwords of database users,
and don't forget to update the XUSER data on all application servers in accordance with Note 39439
after you changed the passwords of the database users.
Regards, Natalia Khlopina
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pablo,
SAP DB 7.3 is quiet an old version. Update to a newer release if possible.
From the above information it is not clear for me which XUSER command are your running. Let me know the exact command.
Have you already created the XUSER entries for users <sid>adm and SAPService<sid> ?
Attach the output of command "xuser -ul".
http://www.sapdb.org/pdf/dbmcli_73eng.pdf (Page 24)
Connect to the database as DBM user and run the following sql command and attach the output-
dbmcli on DB> sql_execute select * from users
Regards,
Yashwanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.