Knowledge Base

Support

Resetting the Control Manager (TMCM) 5.0/5.5 password using OSQL commands

Solution IDLast Updated
1038174Date : 2011/05/11 Time: 11:12 PM (PST)


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

Problem Description

How to reset the password in TMCM 5.0/5.5

Solution

Please do the following:

1.

Open a command DOS console and run the following:

'osql -E'

2.

Replace the 'TMCMADMIN' value to the right user and then run the following commands in OSLQ:

USE DB_CONTROLMANAGER

GO

UPDATE tb_UserInfo

SET Password = '96e79218965eb72c92a549dd5a330112'

WHERE UserGuid IN

(SELECT GUID

FROM tb_Account

WHERE ID ='TMCMADMIN')

You should be able to see "1 row(s) affected".

3.

Restart the TMCM services.

4.

Log on to the to the TMCM console.

The new password should be "111111".


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