Setting the System Administrator password

RAPCache and RAPStoreServer include different administrator default logins. Sybase recommends that you change these logins to protect your system.

StepsAdding the RAPCache administrator

The RAPCache installation creates an administrator called sa. There is no initial password set for this account. Because an sa user can use any database on Adaptive Server with full privileges, Sybase recommends that you create a password to protect your production environment.

  1. In the left pane, click Adaptive Server Enterprise | Default | <RAPCache_server>, where <RAPCache_server> is the name of your RAPCache server.

  2. Click the Logins folder.

  3. In the right pane, right-click sa and choose Properties.

  4. On the Login Properties dialog, click the Parameters tab, then click Change Password.

    The Parameters tab also includes options that allow you to set the minimum password length, maximum login attempts, and expiration period.

  5. On the Change Password dialog:

  6. Click OK.

NoteNotes

StepsAdding the RAPStoreServer administrator

The RAPStore Server installation creates an administrator account with a default user ID (DBA) and password (SQL). The DBA user ID identifies a user with full administration and resource creation rights. The first time you log in to the RAPStoreServer, change the DBA password to protect your production environment.

  1. In the left pane, right-click the Sybase IQ icon and choose Connect.

  2. On the connection dialog, click the Database tab.

  3. From the Server name drop-down box, enter host_name:port_number, where host_name is the name of the machine that hosts the RAPStore server, and port_number is the server port number.

  4. Click the Browse button next to the Database file drop-down box, choose <RAPStore_database_name>.db, where <RAPStore_database_name> is the name of your RAPStore database. Click OK

  5. Click the Identification tab.

  6. Type DBA in the User id box, type SQL in the Password box, click OK.

    You are now connected to the RAPStore database on the RAPStore server. Expand Sybase IQ in the left panel to see the server name. Expand the server name to see the database name.

  7. Expand the database folder, then expand the Users & Groups folder.

  8. Right click DBA and select Properties in the pop-up menu.

  9. In the DBA User Properties dialog, enter and confirm the new DBA password.

  10. Click OK to save and exit the dialog. The new password takes effect immediately for new DBA connections.