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
Urgent: How to reset TM1 admin password with securityadmin
-
- Posts: 122
- Joined: Thu Jan 31, 2013 1:03 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Urgent: How to reset TM1 admin password with securityadm
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).
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
-
- 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
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
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
-
- 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
wang_chris wrote:Our TM1 admin password is locked due to overtimes wrong password logon attemptions.
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.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).
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.
-
- 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
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.wang_chris wrote:Terrible news.
Buy lucky, we made a backup last night, so there won't be much loss.
(Edit: Lotsaram just beat me to this one.)
MaximumLoginAttempts in the tm1.cfg file.wang_chris wrote: But where can we set the logon test times in TM1?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Great news.
I restart the server and it's fine for admin to access system, thank you a million for your all.
Regards,
Chris
I restart the server and it's fine for admin to access system, thank you a million for your all.
Regards,
Chris
-
- 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
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).
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Urgent: How to reset TM1 admin password with securityadm
Thanks guys, indeed I mis-read it like they'd totally forgotten the password.
Robin Mackenzie