SQL Server - Resetting the Dashboard Admin User Password

SQL Server - Resetting the Dashboard Admin User Password

If the Admin user password is changed from default and lost you can reset it through SQL server.

Reset Admin password to EE dashboard login

1) Open SQL Management Studio and run the following query.

select * from eg.sysuser,

2) Look for the SYSUSER_ID of “admin” user, in following example it’s 1.

1 admin Administrator OpenData Administrator

3) Run the query.  

select * from eg.prop_val where obj_id = <SYSUSER_ID> and uom_id = 12

   You should see something like this:

71 1 68 12 BEAF189A671D8FEE6263F28E54ACE81E6B34040E

4) Run following sql:

UPDATE EG.PROP_VAL
SET PROP_VAL = 'BEAF189A671D8FEE6263F28E54ACE81E6B34040E'
WHERE UOM_ID = 12 AND OBJ_ID = <SYSUSER_ID>

   Admin password should be reset to default.

    • Related Articles

    • SQL Server - Removing a Black Box (Offline) Device from the Dashboard

      If a device is offline (server can't communicate with it) for more than 15 minutes its icon will turn into a black box with a white question mark inside. If this device is from a Device Gateway that has been improperly decommissioned you can remove ...

    • SQL Server - Removing (1) from Device Names on the Dashboard

      If a duplicate name occurs on one of the Device Gateways the SQL server will add (1) to the end of the name to distinguish it from the original. Once the duplicate naming issue is solved you may want to remove the (1) from the end of the device name. ...

    • SQL Server - Manual Device Deletion

      If you need to remove a device from the dashboard and it is not possible to use the Delete button on the Administration > Devices page, you can do it through SQL Management Studio. Marking a Device as Deleted In Management Studio run the following ...

    • SQL Server - Testing database connections

      One of the past challenges with troubleshooting SQL database connections has been with having a tool to connect to the SQL database - determining if the port is available on the target server and the service is running. Starting in Windows 10, this ...

    • SQL Server - Deleting Alarm State to Clear False Alarms from the Dashboard

      Occasionally, the alarm status on the dashboard will miss a clear event and it is necessary to delete the alarm state from the database in order to fix the problem. The following procedure steps through this event. Removing an alarm state from the DB ...