Reset Panatracker Administrator password

Reset Panatracker Administrator password

If you have changed your Administrator password for PanatrackerGP and have forgotten it, you can reset it by running the SQL script below.

Reset Procedure

  1. Access your SQL server with SQL Server Management Studio.
  2. Run the password reset script against the PanatrackerGP database.
  3. Refresh your portal page and log in with the default credentials for the portal.

If you don't know the default credentials, contact support at support@panatrack.com.

Password Reset Script 

  1. -- The following script can be used to reset a lost password for the PanatrackerGP 'administrator' account.
  2. -- Run the script against the PanatrackerGP database. Then refresh your portal and log in using the default credentials

  4. BEGIN TRAN t1 
  5. DELETE FROM UserSecurityRole
  6. WHERE       UserOid IN (SELECT Oid
  7. FROM   [User]
  8. WHERE  Username = 'administrator')
  9.  
  10. DELETE FROM [User]
  11. WHERE       Username = 'administrator'

  13. COMMIT


    • Related Articles

    • How to Reset User Password

      You can reset a user's password from the PanatrackerGP Portal. The new password applies to both handheld and portal access. Reset Password Steps Sign into the PanatrackerGP Portal with administrator access. Tap Administration. Tap User ...

    • How to perform an IIS Reset

      An IIS reset stops and restarts the web server process on your application server. It functions like a mini-reboot without affecting the rest of the server. Steps Open Command Prompt as administrator: - Tap Start > All Programs > Accessories > ...

    • Implementing the Panatracker API

      Implementation Steps Install the SubmitFromWebService license. Populate the appropriate Panatracker "Trx" tables with transactions that have a status of Queued. That is, column named TransactionStatus = 1. To trigger the submission, the web API ...

    • Stockroom Inventory User Guide

      Download the Stockroom Inventory User Guide from the attachments tab.

    • Manufacturing User Guide

      Download the Manufacturing User Guide from the attachments tab.