Identify unique login IDs

When users click the 'I forgot my password' link on the Log On page, they must enter their Login ID in the correct alpha case. If users enter their Login ID incorrectly, they will be unable to complete the request for their password information.

To identify user Login IDs which are not unique, you will need to run the Unique Logins Validation Report. This report provides a list of duplicate Login IDs, regardless of alpha case.

Example: Login IDs such as Lsmith, lsmith, lsMith, and other variations are identified as duplicates on the report.

To run the Unique Logins Validation Report:

  1. Log on to the District view.
  2. Click the Tools tab, Reports side-tab. The Reports page appears.
  3. Find and click the Unique Logins Validation Report. The details page appears.
  4. On the Options menu, click Run.
  5. Select the format you want the report to appear in, and then click Run. A list of Login IDs that are not 100% unique appears.

  1. Clean up the duplicate Login IDs, and notify users of any changes made.

  2. Note: Once you have cleaned up the duplicate Login IDs, it is recommended that you run the report again to ensure that all duplicates have been removed.
  1. Run an SQL script against your database to change the column attributes that will enforce unique Login IDs.

Notes:

  • You must have database access to run the SQL script against your database.
  • If you do not have database access, contact Aspen Technical Support.

Once you run the SQL script, the database will set up the columns to be unique. This upgrade will be case insensitive and recognize Lsmith, lsmith, lsMith, and other variations as duplicate IDs.

When you try to add a new user with the same Login ID, an error message will let you know there is already a Login ID in the table.