Change user SAP* Password

[Former Member]

Hello, could some one tell me how can I change the password to user SAP* in SQL Level?

The system is ECC6, running on Windows 2003 Server and SQL 2005 Server

Thanks a lot!!

[Former Member · Accepted solution]

Hey,

run the following sqls:

delete from sap<SID>.usr02 where bname='sap*' and mandt='XXX';

commit;

log on to the system with password: PASS

if still doesn't work, set the profile parameter "login/no_automatic_user_sapstar=0" in your instance profile and restart the SAP instance. (See OSS note 806819).

[Former Member · Accepted solution]

delete from <SID>.usr02 where BNAME='SAP*' and MANDT='XXX';

Be care the small letter and capital letter.

[Former Member · Accepted solution]

Hey Guys,

I already tried the described steps (also in other topics) several times.

I'm using SAP ERP ECC 6.0 with mssql-server.

sql>use <database>;

is ok.

but

sql>delete from USR02 where MANDT = '000' and BNAME = 'SAP*';

doesn't work. It says: Invalid object name 'USR02'.

I also tried SAP<sid>.usr02, lower and uppercase letters, different values for mandt, DDIC instead of SAP* and I added login/no_automatic_user_sapstar = 0 to the profile with restart of the sap-system after saving. BUT nothing works!

Any Ideas?

Thanks a lot.

Lena

[Former Member · Accepted solution]

No it's fixed.

One has to use

sql>setuser '<sid>' -- lowercase SID e.g. 'prd'

after

sql>use <SID> -- uppercase SID

Best regards,

Lena

[former_member749611]

hi all,

any facility to change sap user password via DI API?

thanks.

[Former Member]

Hey,

sap<sid> means you have to replace the <sid> with the SystemID of your system, for example if your SystemID is IDS than use sapIDS.

if you still can not execute the query,

this is due to case sensitive issue,

In order to see the right case, please:

1. activate SQL trace, with transaction ST05

2. execute a simple query on the table USR02 (using transaction SE16)

3. diactivate the trace and than check the exact case of the statement of the table USR02.

4. run the delete statement with the same case of the select (according the the previous step)

[Former Member]

You welcome,

don't forget to reward me some points...

[Former Member]

Thanks a lot!!