How to change password for "Default Admin" user in TIBCO Spotfire Metrics.

How to change password for "Default Admin" user in TIBCO Spotfire Metrics.

If you forget the "Default Admin" user account password in Spotfire Metrics, there is no way to retrieve the old password. But there is a workaround to change that password to a new password. 

To change "Default Admin" user's password to a "admin".

Follow the process below. Note that you need to have the appropriate permissions on SQL Server to run these commands.

/****** Query to get ID from dbo.User table  ******/
SELECT *  FROM [MetricsDatabaseName].[dbo].[User]
Where Alias = 'Admin'  /****** Replace "Admin" with your default admin user account name  ******/

Refer to the attached (Filename: select_query_output.png) for the above query result. Get the "ID" value from the from the previous result and run an updated SQL command to update the password to "jEr6DAqvxAZJOd5yis2skoDAifVHoJ1wDhWhEsX0q9SMRmDW" which is an encrypted form of string "admin" as shown below:


/****** Update SQL command ******/
Update [MetricsDatabaseName].[dbo].[UserCredential]
set Password = 'jEr6DAqvxAZJOd5yis2skoDAifVHoJ1wDhWhEsX0q9SMRmDW'
where ID = '3EFD4A11-2036-E511-8272-005056C00008'

After running the above SQL query, you can login with username\password as "Default Admin\admin". It is strongly recommended to save the "Default Admin" user's password to avoid running into this issue.