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.

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.