Reset an Administrator Password in SmarterTrack

In most cases, a user password can be changed through the Management Interface in SmarterTrack. If the password for an administrator account is unavailable, another administrator can change the password for them.

However, if access to the Management Interface is restricted, due to no administrators being able to log in, follow the procedure below to change a user password in the database directly.

Applies to all versions of SmarterTrack

Microsoft SQL Server

  1. Open IIS and stop the SmarterTrack app pool. (If you are running an older version and using SmarterTrack's web server, stop the SmarterTrack web server instead.)
  2. Open SQL Server Management Studio.
  3. Run the following query, substituting PASSWORD with the desired password and USERNAME with the user's login name:
    NOTE: If you use a different database table prefix in your database, you will need to alter the st_Users table name in the queries accordingly.
    update [dbo].[st_Users]
    set [Password]='PASSWORD', [PasswordFormat]=1, [AuthenticationType]=0
    where [UserName]='USERNAME';
  4. Start the SmarterTrack app pool. (If you are running an older version and using SmarterTrack's web server, start the SmarterTrack web server instead.)
  5. You should now be able to log in to SmarterTrack using the USERNAME and PASSWORD you specified.

MySql

  1. Open IIS and stop the SmarterTrack app pool. (If you are running an older version and using SmarterTrack's web server, stop the SmarterTrack web server instead.)
  2. Open MySql Administrator or another MySql console application.
  3. Run the following query, substituting PASSWORD with the desired password and USERNAME with the user's login name:
    NOTE: If you use a different database table prefix in your database, you will need to alter the st_Users table name in the queries accordingly. 
    update st_Users
    set Password='PASSWORD', PasswordFormat=1, AuthenticationType=0
    where UserName='USERNAME';
  4. Start the SmarterTrack app pool. (If you are running an older version and using SmarterTrack's web server, start the SmarterTrack web server instead.)
  5. You should now be able to log in to SmarterTrack using the USERNAME and PASSWORD you specified.

 

Learn more about the SmarterTrack online help desk and how you can improve your overall customer service.

Feedback

Add Feedback
seems not working anymore, for current version
Markus Gufler (February 1 at 6:28 AM)
Thank you for bringing this to our attention, Markus. We will look into this issue right away.
Andrea Rogers (February 4 at 3:31 PM)
Markus, a recent change to SmarterTrack's internal caches has required changes to these steps. Prior to running the database query, the app pool must be stopped. Once it has been restarted, the password reset will take effect. I have updated this article accordingly.
Andrea Rogers (March 6 at 10:04 AM)
Thank you very much.
Markus Gufler (March 6 at 11:08 AM)
Same issue... I really need to reset the admin password...
Dustin Jurman (February 27 at 10:16 PM)
Dustin, a recent change to SmarterTrack's internal caches has required changes to these steps. Prior to running the database query, the app pool must be stopped. Once it has been restarted, the password reset will take effect. I have updated this article accordingly.
Andrea Rogers (March 6 at 10:05 AM)