change password connect SAPR3 to MS SQL Server

[Former Member]

hello.

want to change password for all logins in MS SQL Server.

how its correctly change password for SAP logins?

or where i can change password for SAP so, that we can work in SAP.

thank you.

[Former Member]

as i said below, i dont have access to sap notes, because our boss faired, and dont leave any password, can u send sap note to my e-mail address plz. thank you.

[JPReyes]

Quote from SAP Note 50088

 IIa  Changing the password for the user 'sapr3'
If the OPS$ user has already been created as described above, the password for the 'sapr3' user can be changed at any time. As user <SAPSID>ADM, you must follow two steps (replace <new password> with the new password for the user 'sapr3'):
1. Stop the SAP System.
2. Log on as user <SAPSID>ADM to the host on which the R/3 database for the SAP System is running.
All the following actions have to be carried out on this host.
3. Change the entry for the user 'sapr3' in table SAPUSER.
a) Start sqldba72 (or svrmgr23, svrmgr30) and log on to the database with 'connect internal'.
b) Execute an update on the table SAPUSER.
'update OPS$<SAPSID>ADM.SAPUSER set PASSWD='<new password>'
where USERID='SAPR3';'
4. Change the password for the 'sapr3' user the database with the following commands:
'connect internal'
'alter user sapr3 identified by <new password>;' 

[Former Member]

how SAP server know new password?

i know how to change login password for MS SQL Server.

but i afraid if i change that, SAP won't work.

[JPReyes]

Follow the note... that info is there.

regards

Juan

[Former Member]

can u show me text plz for changing?

have no access, because old boss is gone and noone know pass..

[JPReyes]

You don't have access???? thats an issue....

If you run command sqlplus "/as sysdba" at command prompt you should be able to enter the SQL command prompt... just use the alter user <enter_user> identified by <new_password>;

regards

Juan

[JPReyes]

Hi Aleksey,

procedure to change the password for SAPR3 is described in SAP Note 50088 - Creating OPS$ users on Windows NT/Oracle

Regards

Juan