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.

If access to the management interface is restricted, however, due to no administrators being able to log in, follow the procedure below to change a user password in the database directly.

Applies to SmarterTrack 6.x - 12.x

Microsoft SQL Server

  1. Open SQL Server Management Studio
  2. Run the following query, substituting PASSWORD with the desired password and USERNAME with the user's login name
update [dbo].[st_Users]
set [Password]='PASSWORD', [PasswordFormat]=1, [AuthenticationType]=0
where [UserName]='USERNAME';

MySql

  1. Open MySql Administrator or another MySql console application
  2. Run the following query, substituting PASSWORD with the desired password and USERNAME with the user's login name
update st_Users
set Password='PASSWORD', PasswordFormat=1, AuthenticationType=0
where UserName='USERNAME';

Note that if you use a different database table prefix in your database, you will need to alter the st_Users table name in the queries above.

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.

Add Feedback