Rolling back the password for the user ADMIN

Post Reply
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Rolling back the password for the user ADMIN

Post by Radhika »

Hi All,

I have installed TM1 v9.5.1 on Windows 2003 SP2 machine.
After installation I have created a application, in which there exists only one admin user. Recently I have reset the password of the admin user, now I forgot the password.

Is there anyway wherein I can rollback the password of the Admin user.

Please guide me over the process.

Thank you,
Radhika
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Rolling back the password for the user ADMIN

Post by jim wood »

If you bring the server down, delete the security cubes and restart the server it will rebuild the security cubes with only the admin user in place with a blank password. The problem with this is if you have other users setup it will remove them. I awlays create another admin user at the very begining and use that rather than admin itself. Always keeps things simpler,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
qml
MVP
Posts: 1098
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: Rolling back the password for the user ADMIN

Post by qml »

I can't remember right now, but if you just delete the }ClientProperties cube, would that still erase all the users from the server? This should be enough to zero out all the passwords.
Kamil Arendt
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: Rolling back the password for the user ADMIN

Post by kpk »

qml wrote:I can't remember right now, but if you just delete the }ClientProperties cube, would that still erase all the users from the server? This should be enough to zero out all the passwords.
Yes, deleting the }ClientProperties cube erase all the passwords.

If you do not want to erase all the other passwords, but admin and you have at least one process
which can be run by any non admin user who can help you then you can try the following:

1. Create a process in a dev environment or (in a local server) which add a new user and assign the user to admin group.
2. Shut down the server.
3. Replace the process (which can be run by other user) temporary with the new pro file.
4. Start the server.
5. Run the process and you have a new admin theoretically. I have not tried it!
6. Change the Admin password.
7. Stop the server.
8. Copy back the pro file.
9. Start the server.

HTH

Peter
Best Regards,
Peter
Radhika
Posts: 97
Joined: Mon Sep 27, 2010 6:49 am
OLAP Product: IBM Cognos TM1
Version: v9.4.1
Excel Version: Microsoft Excel 2003

Re: Rolling back the password for the user ADMIN

Post by Radhika »

Hi All,

Thank you very much for your valuable suggestions.

Regards,
Radhika
Post Reply