client 000 locked

[Former Member]

I have Installed SAP ECC 6.0 IDES versinon on SQL database, I am not able to login to client 000 and cleint 001 with sap* user and DDIC user can any one suggest me .

[Former Member]

HI,

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='000' and BNAME = 'SAP*'

where SID = your sap system id ID in uppercase

sid = your sap system id in lowercase

after executing query

make sure profile parameter login/no_automatic_user_sapstar set to 0 if not set it and activate the profile and restart sap server.

now login into client 000 with user sap* and password 'pass'

regards,

kaushal