Reset Password On-Prem User

[epoveda_ac]

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: 

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

[IftaqarAhmed · Accepted solution]

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