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

Solution ID:

 EN-1038174

Product:

 Control Manager - 5.0
Operating System:
 Windows Server 2003 Enterprise Edition - SP1; Windows Server 2003 Standard Edition - SP1; Windows Server 2003 x64; Windows 2000 Server - SP4

Published:

 9/23/2008 5:12 PM 
 

Solution:
Public
 

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?           Comments:
 Yes     No
         
           
            This form uses an automated system and does not provide feedback.