Skip to main content
E
e_poveda
August 19, 2024
Solved

Reset Password On-Prem User

  • August 19, 2024
  • 1 reply
  • 0 views

Hi, 

I've been offline during few weeks without using OneStream on my localhost application, and now, when I try to connect to my localhost again, I can't login: 


epoveda_ac_0-1724068315248.png

Of course, I don't change my password during these weeks. How can I reset my password? Or anyone had the same issue? 

Thanks in advance for any tip. 

Regards,

Eduardo

Best answer by IftaqarAhmed

To re-enable the administrator account in OneStream, you can run the following command on the Framework database. 

update SecUser
set EncryptedPassword = '' -- No spaces
where Name = 'Administrator';

Caution: Before you proceed, it’s wise to back up the database to avoid any issues. This should only be done in a local or lab environment—do not perform this in a real or live environment. Making changes directly to the database can sometimes lead to unexpected results.

After running this, you should be able to set a new password when you log in next.

Regards,

Iftaqar

1 reply

I
IftaqarAhmedAnswer
August 19, 2024

To re-enable the administrator account in OneStream, you can run the following command on the Framework database. 

update SecUser
set EncryptedPassword = '' -- No spaces
where Name = 'Administrator';

Caution: Before you proceed, it’s wise to back up the database to avoid any issues. This should only be done in a local or lab environment—do not perform this in a real or live environment. Making changes directly to the database can sometimes lead to unexpected results.

After running this, you should be able to set a new password when you log in next.

Regards,

Iftaqar

Terms & ConditionsAccessibility statement