how to reset password from sql level

[Former Member]

Dear All,

I have created a new client 300 which is a copy of 000,

i have selected only SAP_CUST profile, no user master profile is selected.

After creation of client i have created one user,

now only one user is existing in newly created client 300, unfortunately , i am unable to login using that user,

for which i have to reset the password,

how do i proceed to attend this issue.Can i do it from OS level or SQL level,, if so then please let me know how do i proceed for it.

regards,

SM

[Former Member]

Hi,

you can not reset password of SAP user at OS level or database level.

login with sap* user into client 300 and change the password of that user.

regards,

kaushal

[Former Member]

i am unable to login using sap* and password as PASS,

i had created user USER1 for which i have to reset the password...

[Former Member]

HI,

use the source client password for SAP*

suppose you copied 300 client from source client 000 then use 000 sap* password in 300

if you are still getting problem with login using sap* in client 300

then do following

run query analyzer if you use SQl server 2000

or run sql server management studio if you use SQL 2005

connect to database

use folloiwng query

in SQL 2005 click on new query

USE SID

DELETE sid.USR02 where MANDT='300' and BNAME = 'SAP*'

where SID = your sap system id ID in uppercase

sid = your sap system id in lowercase

query is case sensitive

after executing query login with sap* user and password 'pass'.

regards,

kaushal

regards,

kaushal

[Former Member]

hi,

Parameter login/no_automatic_user_sapstar = 0 must be set in the instance profile and the system must be restarted before it's activated.

Secondly, password for SAP* in a new client is "pass" with lowercase.

[Former Member]

Hi,

Thanks for the query , This is the first time i am running the query..

DELETE qas.USR02 where MANDT='300' and BNAME = 'SAP*'

i got the error.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'qas.USR02'.

[Former Member]

Hi,

there is no error in query.

Is your SAP SID is QAS ?

check similar

regards,

kaushal

[clas_hortien]

Hi,

the query must look like

DELETE FROM qas.USR02 where MANDT='300' and BNAME = 'SAP*'

Regards

Clas Hortien