Changing Passwords 

Use

When R/3 and the SQL Server are installed, the users sa , and sapr3 are created.

The user sa has system administration privileges for the SQL Server. Anyone who logs on as sa , can perform all the tasks available on the server without any restrictions. Initially no password is assigned to sa . It is therefore important to assign a password to this user directly after the installation of R/3 to prevent unauthorized use of the associated privileges. Before you can assign a password to sa , you have to make sure that the server involved has been registered.

The second user that is created during the installation, sapr3, is the owner (dbo) of the R/3 database. sapr3 has system administrator privileges that allow the execution of all tasks on the R/3 database, including the definition of privileges for other users. Initially sapr3 is assigned the password sap . To prevent inappropriate use of this user, change the password immediately after the installation.

The R/3 System connects to the database with the NT accounts SapService<SAPSID> or <SAPSID>adm . At this level, Windows NT authentication is used to ensure the security of the connection to the database and no password is required. However, when you initially log on to NT as SapService<SAPSID> or <SAPSID>adm , you need to enter a password. It is important to ensure the security of this password to protect the database against unauthorized access. If necessary, change the password following the instructions given in the Windows NT documentation.

Procedure

  1. In the Enterprise Manager, expand the server and Security.
  2. Under Security choose Logins.

    3. The results pane shows the users sa and sapr3 .

  3. Select the user for which you want to change the password and choose Action ® Properties.
  4. The SQL Server Login Properties dialog box opens.
  5. On the General tab, enter a new password for the user you have selected.
  6. When you change the password for sa , the master database is specified as the default database for the login.

    7. When you change the password for sapr3 , the R/3 database <SAPSID> is specified as the default database for the login.

  7. Choose OK and confirm your password.

The new password is now valid.

After changing the password of the login sa , you have to re-register the server in the Enterprise Manager.