| Resetting the password in Control Manager (TMCM) 5.0 |
| |
|
|
| |
Solution: |
|
Please do the following:
|
|
|
|
1.
|
Stop the TMCM services.
|
|
|
|
|
2.
|
Launch the SQL Server Enterprise Manager of the SQL Management Studio.
|
|
|
|
|
3.
|
Open the “tb_Account” table.
|
|
|
|
|
4.
|
Look for the GUID of the account you wish to modify.
|
|
|
|
|
5.
|
Open the “tb_UserInfo” table.
|
|
|
|
|
6.
|
Look for the “UserGuid” that you got from the “tb_Account” table.
|
|
|
|
|
7.
|
Modify “password” to “96e79218965eb72c92a549dd5a330112”.
|
|
|
|
|
8.
|
Start the TMCM services.
|
|
|
|
|
9.
|
The password for TMCM is “111111”.
|
|
|
|
|
|
Similarly, you can use the SQL statements to update the entry. These statements can be run using any preferred SQL query tool.
|
|
|
|
The following is an example of how you can reset a user name “TMCMADMIN”:
|
|
|
|
|
USE DB_CONTROLMANAGER
GO
UPDATE tb_UserInfo
SET Password = '96e79218965eb72c92a549dd5a330112'
WHERE UserGuid IN
(SELECT GUID FROM tb_Account WHERE ID ='TMCMADMIN')
|
|
|
|
Replace the "TMCMADMIN" above with the account name that you want to reset the password.
|
|
|
|
|