Overview
The default Carousel 7 Admin user is the master account that has access to every setting in the user interface including the ability to create and reset other admin accounts. By running a SQL script on the FrontDoor database you can reset the password to the default to recover this account if needed.
Note: If Active Directory integration is enabled, the build-in Admin account is disabled. Resetting the Admin password in this configuration will not provide access when you try to log in.
Where to start
Log into your Carousel server’s Windows environment as an account with database owner rights and open SQL Server Management Studio. If you have a separate SQL instance, access it as you normally would.
Resetting the Admin Password
With SQL Management Studio open and connected, click the “New Query” button at the top and run the following SQL script:
USE Frontdoor50;
DECLARE @userid uniqueidentifier
SELECT @userid=UserId FROM aspnet_Users WHERE LoweredUserName = 'admin'
UPDATE aspnet_Membership SET Password='BSNgKgDtVFHW+djpYzs5psP+TaU=', PasswordSalt='XuURIiUKPoPdDzHIYdAGQw==', PasswordFormat=1, IsLockedOut=0, FailedPasswordAttemptCount=0 WHERE UserId = @userid
You can also find the .SQL file on your server located on the installation drive in /TRMS/Database/Scripts/ResetAdminPassword.sql
Final Steps
Once ran, open the FrontDoor login screen and sign in with the username of Admin the password of trms - this must be done from the Carousel server itself, you cannot login with default credentials from another computer.
After you log in you will be required to set a new permanent password. This admin account can then reset passwords for other users in FrontDoor.