Created On:  14 February 2011

Problem:

How can I reset the admin user's password using SQL?

Resolution:

The normal method to reset the password for the admin user account for CaliberRDM is to log into the admin console, click on the profile icon in the top right hand corner and then enter the new password. If however you have forgotten the admin users password you can run the following SQL statement using a SQL Server query tool. Please ensure you take a backup of the database before making such changes.

Update [DB Name].[dbo].[TDUSERS]
Set password = 'a726d2ec21'
Where USERNAME = 'admin'

Where [DB Name] is the name you have given your database. By default this is called crdmdb.
This will reset the admin user's password back to admin.
This requires a restart of the CaliberRDM Server before changes take effect.