How Reset SAP* and DDIC Password in MSSQL Server 20005 on window

[Former Member]

Hi

How I Reset SAP* and DDIC Password in MSSQL Server 20005 on window 2003 server .Brtools not working in here.<b>Please help me</b>

Thanks

Kumar

[Former Member · Accepted solution]

Hello Kumar,

Password reseting for SAP user ids is not possible at DB level as far as I know. Locking/unlocking,deletion etc. is. Anyways even if it is you need to use SQL query analyzer and not .br tools.

Regards.

Ruchit.

[Former Member · Accepted solution]

Execute the query to delete SAP* from 000 using MS SQL Query analyzer

DELETE FROM SAPR3.USR02 WHERE MANDT='<CLIENT>' AND BNAME='SAP*'

Where SAPR3 => MS SQL Schema.

Sorry!!!!!!!! I reply in hurry it is to delete the user not reset the password.

To reset the password you will require additional knowledge of Database Administration.

Regards,

Santosh Karadkar

Message was edited by:

Santosh Karadkar

[Former Member · Accepted solution]

Hi

I Know process Oracle database but my problem is MSSQL Server 2005.I am not able login client 001 user name sap* or DDIC how i login in client 001.I am able login client 000.But not in 001.

Please help me

Thanks

Kumar

[Former Member · Accepted solution]

Hello Kumar,

Once you logon to Query analyser

Run this command delete from <SID>.USR02 where BNAME='SAP*' and MANDT='001'. Then run the query.

Ensure all the charecters in USR are capital and <SID>= SID of your system.

Thanks & Regards

Vivek

[Former Member · Accepted solution]

Hi Vivekanada,

Thanks problem solve.

Thanks

kumar