How To - Reset Admin Account using sqllitestudiocli

How To: Reset Admin Account using SQLliteStudio CLI

Question

How can you reset the admin account?

Reasoning

When an admin user can't log in and support ticket submission isn't possible, one way to regain access is by directly modifying or clearing specific data in the database. Using sqlitestudiocli, you can open the .db file and execute SQL commands to reset or delete parameters related to the admin account.

Answer

Use sqlitestudiocli to open the .db file and run SQL commands (such as deleting from nxUserParams) to reset admin login settings.

Steps

1. Navigate to Titan installation folder and look for utils folder.
   Default path: “C:\Program Files\South River Technologies\srxserver\utils”
   
   
2. Launch Sqlitestudio installer
   
   
   
3. Run CMD with Administrator privilege.
4. Change Directory to SqliteStudio installation folder.
   Default path: "C:\Program Files\SQLiteStudio"
   
   
   
5. Connect to Titan Default Administration Database
   Command: sqlitestudiocli "c:\programdata\South River Technologies\srxserver\database\lasdb.db"
   
   
   
6. Drop the nxUserParams table
   Command: DROP TABLE nxUserParams;
   
   
   
7. Restart Titan windows Service.
   Press Windows Key + R > type services.msc > Search and locate Titan Service > Right click and select restart.
   
   
   
8. Go to Titan Administration Log in page and set new Administration account.
   
   
   
9. After creation of new Admin Account. Exit the sqlitestudiocli
   Command: .exit