DDIC Locked - Password Logon is not possible
I have installed an IDES (ECC 6.0) on MS SQL 2005. I tried to login to the server using DDIC as the username and the master password that I had setup. However, it didn't allow me to login and after a few tries, it gave a error message that "password logon is not possible". Is it possible to login to the database and change / reset the login? Or is there any alternate solution to fix this issue?
Thanks in Advance,
Please note that USR02 is owned by SAP. so you've to give the correct schema-id which owns this table. in this case it would be SAPID1.
DELETE FROM <schema-id>.USR02
WHERE BNAME='SAP*' AND MANDT='<client no.>'
hope this helps.