Lost Admin password

Post Reply
swati_phadtare
Posts: 14
Joined: Mon Mar 28, 2011 9:21 am
OLAP Product: TM1
Version: 9.5
Excel Version: 200

Lost Admin password

Post by swati_phadtare »

Hi All,
I have lost our Admin password of the application.
Please let me know how to retreive the admin password.
If not possible then how to reset it.
Regards
User avatar
qml
MVP
Posts: 1096
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Lost Admin password

Post by qml »

Depending on whether you have any other account that has Admin or SecurityAdmin privileges, you can use that account to delete the password directly from the }ClientProperties cube (manually, via TI or via the security GUI).

If you were careless enough not to have a backup Admin account then your next option is to delete the }ClientProperties.cub file from the data directory and restart the server. Be aware that this will remove passwords and other user settings for all users, not just Admin!
Kamil Arendt
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Lost Admin password

Post by declanr »

Another option would be messy but feasible...


Find a user that has access to run a TI, any given TI will do.

In your dev environment (if you have one and access to it) create a TI that uses the AssignClientPassword function.

Copy and paste that into the production environment after naming it the same as the TI your standard user has access to (make a copy of what it is replacing of course.)


Run and replace your admin password... in the event that you don't have a Dev environment I expect the bedrock site may have a TI that does this?


But definitely always have at least 2 admin users - just for the sake of resetting each others passwords.

HTH



Edit - I should add that I have never actually tested this and I am just presuming it might work - would be good to know if it actually does...
Declan Rodger
Post Reply