delete sap* at database level

[Former Member]

hello sir

how can i delete sap* at database level so that i can unlock the sap*and ddic user.

[Former Member]

- login to the server via mstsc as user <sid>adm.

- start sql server management studio

- press "Connect"

- press "New Query"

- enter this commands and press F5 afterwards:

use <SID>

go

setuser '<sid>'

go

delete from USR02 where MANDT='<your_client>' and BNAME='SAP*'

- Afterwards you should be able to logon with SAP* and password PASS

- Please note that parameter login/no_automatic_user_sapstar must be set to 0 (zero)

otherwise you can not logon.