Changing the Password for Database Access

Context

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

To change the password for user SAPR3, follow the procedure described below:

Procedure

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

Note

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

For this, log on as user SAPR3 (default value for the password: SAP) on the affected database instance.
Under View Direct SQL, enter as a New SQL Statement the command OLD PASSWORD<old password> TO <new password>.
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.
The database user and the new password now just have to be encrypted and stored in file ContentServer.ini/cs.conf. 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 SAP Note 661852 .