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
- Navigate to Titan installation folder and look for utils folder.
Default path: “C:\Program Files\South River Technologies\srxserver\utils” - Launch Sqlitestudio installer
- Run CMD with Administrator privilege.
- Change Directory to SqliteStudio installation folder.
Default path: "C:\Program Files\SQLiteStudio" - Connect to Titan Default Administration Database
Command: sqlitestudiocli "c:\programdata\South River Technologies\srxserver\database\lasdb.db" - Drop the nxUserParams table
Command: DROP TABLE nxUserParams; - Restart Titan windows Service.
Press Windows Key + R > type services.msc > Search and locate Titan Service > Right click and select restart. - Go to Titan Administration Log in page and set new Administration account.
- After creation of new Admin Account. Exit the sqlitestudiocli
Command: .exit
***End
Related Articles
How To - Reset Admin Password
How To: Reset Admin Password Question How can I reset the admin password if I’ve forgotten it or lost access? Reasoning For security and administrative continuity, it’s essential to have a reliable method to regain access to an admin account. A ...How To: Turn off the Admin idle timeout
How To: Turn off the Admin idle timeout Question How can we turn off the Admin idle timeout? Answer You can turn off the idle timeout in the Admin Console by the following NXCLI and Powershell commands Commands to use for NXCLI and PowerShell Using ...How To Setup Remote Admin for Titan
How To: Setup Remote Administration for Titan Question How can I configure Remote Administration for Titan Server? Reasoning We want to manage the server remotely from another system. Answer You can easily configure your Titan Server for remote ...How To Apply, Update, Delete Registration Code or License
Apply, Delete, Update Registration Code / License Question How do I apply, delete, or update my license for Titan Server? Reasoning In addition to initial server setup and activation, product Licenses need to be updated each time renewal occurs for ...How To: Give Users Admin Permissions
How To: Give Users Admin Permissions Question How do I give a user admin capability? Reasoning Managing and administering Titan can be time-consuming, so delegating some of the tasks to a second user would be very helpful. Answer You can enable the ...