Maintained for Historical Purposes

This resource is being maintained for historical purposes only and is not currently applicable.

Tip of the Week: The SYSADMIN User ID

PublicationDate: 4/16/99
Summary: Tip of the Week: The SYSADMIN User ID
Author: CPS - Central Processing System (CPS)


Posted on April 16, 1999

TO: All Destination Points
FROM: CPS Customer Service
RE: Tip of the Week: The SYSADMIN User ID

This week's tip highlights a feature or process in 1999-2000 EDExpress and
32-bit SSCR: The SYSADMIN User ID

In 1999-2000 EDExpress and 32-bit SSCR, you must use SYSADMIN as the default User ID and password the first time you log into the software (following afull installation). Once entered, you are prompted to enter a new password and to verify it (by re-entering it). Make a note of this new password and have in a secure place, as it will be your only system administration password.

The User ID SYSADMIN (and the unique password for it you create upon your initial logon) should be reserved for administration purposes only. The primary use for SYSADMIN is to clear the message "user ID already logged in "for those users who may have experienced PC or system problems while EDExpress or SSCR were open. SYSADMIN should not be used as a routine User ID for modifying student records or performing other everyday tasks within EDExpress or SSCR.

System or PC errors can occur while you are logged into EDExpress or SSCR. These errors can damage the security table of your database, which stores passwords and levels of access by individual users. As with other User IDs, you may find that the SYSADMIN User ID creates a record lock (or an "already logged in message") if you use it to process records.

As the SYSADMIN User ID is "hidden" in the EDExpress and SSCR databases (it will not appear under ToolsUsers), any record locks associated with it may not be apparent, and frequently do not appear on the Clear Record Locks utilities screen. The crash of your system while logged in as SYSADMIN could therefore cause you to be locked out of the database altogether with an "already logged in message."

There is no way to clear the "already logged in message" for SYSADMIN User ID. Historically, some schools, when faced with a damaged security table, have had to restore a backup or rebuild their database after experiencing system errors or crashes while logged in with the SYSADMIN User ID.

For this reason, we are recommending that users use the SYSADMIN user only as an administrative tool. You should create and use separate User IDs and passwords for performing your routine EDExpress and SSCR processing activities, such as entry, import and export.

If you have any questions, please contact CPS Customer Service at 800-330-5947, or via email at CPS@NCS.COM.

Last Modified: 08/16/1999