Tips & Tricks #2: How to reset a lost password in FPSC v11.5


Solving For:

I have lost the password to my FPSC administrator account.
Solution:
Overwrite the unknown administrator account’s password hash with a known password hash.
Details:
If you have lost your administrator password to FootPrints Service Core v11.5, this is how you can reset it to a known value.
STEP 1:
Log into SQL Server Management Studio and open the Footprints database.
STEP 2:
Navigate to the dbo.users table.
STEP 3:
Paste the following hash into the password field for the appropriate account.

  • Password has for the password “root
    • KNiI95fCWzWKw


STEP 4:
Verify that the authentication_method field is set to either PRIMARY or SECONDARY depending upon which you have set to internal FootPrints Authentication.

VERIFICATION:
Verify that you can log in using the account whose password you just overlaid.
 by Evans Martin, RightStar Systems

2013-03-09T21:57:51+00:00March 9th, 2013|FPSC|