Knowledge Base

Support

Resetting the password in Control Manager (TMCM) 5.0/5.5

Solution IDLast Updated
1037073Date : 2011/05/12 Time: 2:47 AM (PST)


Product/VersionPlatform
Control Manager - 5.0, 5.5
Windows - 2000 Server, 2000 Advanced Server, 2003 Standard Server Edition, 2003 Enterprise Server, 2003 Standard Server Edition 64-bit

Problem Description

This article provides procedures on how to reset the TMCM password.

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.


Rate this Solution
Did this article help you?  
 
Please provide your comments to help us improve this solution.

 
  *This form is an automated system. General questions, technical, sales and product-related issues submitted through this form will not be answered.
 
 

Connect with us on