Urgent: How to reset TM1 admin password with securityadmin

Post Reply
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Urgent: How to reset TM1 admin password with securityadmin

Post by wang_chris »

Urgent.

Our TM1 admin password is locked due to overtimes wrong password logon attemptions.

Now as a securityadmin, how can we reset or release the admin's password?

Regards,
Chris
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Urgent: How to reset TM1 admin password with securityadm

Post by rmackenzie »

SecurityAdmins cannot assign people to the Admin group, including themselves. Nor can they assign themselves to DataAdmin.

The classic route out of this trap is to restart your server without }ClientProperties.cub. In the process you will lose all the passwords so you need a smart strategy to reset them to something after the server comes back up (i.e. write a TI to do this).
Robin Mackenzie
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Re: Urgent: How to reset TM1 admin password with securityadm

Post by wang_chris »

Terrible news.

Buy lucky, we made a backup last night, so there won't be much loss.

But where can we set the logon test times in TM1?

Regards,
Chris
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Urgent: How to reset TM1 admin password with securityadm

Post by lotsaram »

wang_chris wrote:Our TM1 admin password is locked due to overtimes wrong password logon attemptions.
rmackenzie wrote:SecurityAdmins cannot assign people to the Admin group, including themselves. Nor can they assign themselves to DataAdmin.

The classic route out of this trap is to restart your server without }ClientProperties.cub. In the process you will lose all the passwords so you need a smart strategy to reset them to something after the server comes back up (i.e. write a TI to do this).
I think you misread the OP's problem. I *think* they are saying that the Admin account is locked due to maximum number of logon attempts exceeded. In which case a server restart would unlock the account, no need to remove the password unless no one knows what it is.
Last edited by lotsaram on Fri Dec 05, 2014 7:47 am, edited 1 time in total.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Urgent: How to reset TM1 admin password with securityadm

Post by Alan Kirk »

wang_chris wrote:Terrible news.

Buy lucky, we made a backup last night, so there won't be much loss.
Robin's suggestion was based on the assumption that you had forgotten the password. If you simply mis-entered it too many times, rebooting the server alone will clear the problem.
(Edit: Lotsaram just beat me to this one.)
wang_chris wrote: But where can we set the logon test times in TM1?
MaximumLoginAttempts in the tm1.cfg file.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
wang_chris
Posts: 122
Joined: Thu Jan 31, 2013 1:03 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2007

Re: Urgent: How to reset TM1 admin password with securityadm

Post by wang_chris »

Great news.

I restart the server and it's fine for admin to access system, thank you a million for your all.


Regards,
Chris
Gabor
MVP
Posts: 170
Joined: Fri Dec 10, 2010 4:07 pm
OLAP Product: TM1
Version: [2.x ...] 11.x / PAL 2.1.13
Excel Version: Excel 2016-2021-365
Location: Germany

Re: Urgent: How to reset TM1 admin password with securityadm

Post by Gabor »

Another proven technique is to simply increase the "MaximumLoginAttempts" parameter (because it's dynamic) in tm1s.cfg for a few seconds and login before you go back to the original value. If it is not there, you need to add it with a higher value than 3 (default).
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Urgent: How to reset TM1 admin password with securityadm

Post by rmackenzie »

Thanks guys, indeed I mis-read it like they'd totally forgotten the password.
Robin Mackenzie
Post Reply