Changing the Password for Database Access 

Use

The SAP Content Server uses the Database User SAPR3 for accessing its Database Instance. You can change the standard password for this user, in order to prevent the database instance from unauthorized use.

To change the password, follow the procedure described below.

Procedure

...

       1.      Change the password in the database instance using the tool SQL Studio.

You can install SQL Studio from the WEB AS 6.20 Server Components CD 2.

Log on to the relevant database instance as user SAPR3 (default password: SAP).

       2.      Under View  → Direct SQL, enter as a New SQL Statement the command OLD PASSWORD<old password> TO <new password>.

 

       3.      To execute the command, enter CTRL+F5 or choose the exclamation mark icon .

If you do not receive any error messages, the new password has been successfully set up in the database.

       4.      The database user and the new password now just have to be encryped and stored in file ContentServer.ini/cs.conf abgelegt werden. To encrypt and set the user name and password use report RSCMSPWS in the SAP system. Then you can reset the user and the password either for a repository or for the whole content server. See also Note 661852.