*** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user na

[Former Member]

Hello

I have just finished a dbcopy of Maxdb 7.6 to a new system with initilization.i can bring the db online. I have ran the xuser command to fix the db users as below command as per note 39439

i changed them in home dir of sidadm,sqdsid

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

c) DBM user: for example, CONTROL.

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

d) SYSDBA user: for example, SUPERDBA.

xuser -U w -u SUPERDBA,<password> -d <database_name> -n <database_server> -S INTERNAL set

But iam having the below error now when trying to bring the SAP system up in dev_w0

C Try to connect (DEFAULT) onconnection 0 ...

C

C Mon Dec 19 21:46:11 2011

C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combinati

on)

[dbsdbsql.cpp 137]

B ***LOG BY2=> sql error -4008 performing CON [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY0=> POS(1) Unknown user name/password combination [dbsh#3 @ 1208] [dbsh 1208 ]

B ***LOG BY2=> sql error -4008 performing CON [dblink#8 @ 433] [dblink 0433 ]

B ***LOG BY0=> POS(1) Unknown user name/password combination [dblink#8 @ 433] [dblink 0433 ]

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1537]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10837]

M

is there something that i missed somewhere?

Any ideas welcome

[former_member229109 · Accepted solution]

Hello,

according posted information:

"

C Try to connect (DEFAULT) onconnection 0 ...

C

C Mon Dec 19 21:46:11 2011

C *** ERROR => Connect to database failed, rc = -4008 (POS(1) Unknown user name/password combinati

on)

"

Please pay attention to the d) recommended steps in the note 129352.

Please check with OS users sidadm,sqdsid that you could connect to the database with DEFAULT key settings for XUSER:

sqlcli -U DEFAULT ...

or

dbmcli -U c -USQL sql_execute "select * from users"

Please follow the note 39439 and check/set the XUSER entry for the default key correctly for the OS user, which restart the application server.

Regards, Natalia Khlopina

[Former Member · Accepted solution]

thanx to all ,the problem wasnt with the DEFAULT user but with the user who owns the application data SAP<SID>.it resolved the problem after changing it to the new SID

[Former Member]

resolved the problem

[former_member188883]

Hi,

Could you re-check your Xuser creation for default connection

Additionally paste the output of command

xuser list

Regards,

Deepak Kori

[Former Member]

erpsyscs1:cs1adm 46> xuser list

-

---

XUSER Entry 1

-

---

Key :DEFAULT

Username :SAPCS1

UsernameUCS2:S.A.P.C.S.1. . . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :CS1

Nodename :erpsyscs1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 2

-

---

Key :c

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :CS1

Nodename :erpsyscs1

Sqlmode :INTERNAL

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>

-

---

XUSER Entry 3

-

---

Key :c_J2EE

Username :CONTROL

UsernameUCS2:C.O.N.T.R.O.L. . . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :CS1

Nodename :erpsyscs1

Sqlmode :SAPR3

Cachelimit :-1

Timeout

Isolation

Charset :<unspecified>

-

---

XUSER Entry 4

-

---

Key :w

Username :SUPERDBA

UsernameUCS2:S.U.P.E.R.D.B.A. . . . . . . . . . . . . . . . . . . . . . . . .

Password :?????????

PasswordUCS2:?????????

Dbname :CS1

Nodename :erpsyscs1

Sqlmode :INTERNAL

Cachelimit :-1

Timeout :-1

Isolation :-1

Charset :<unspecified>