Forum Discussion

epoveda_ac's avatar
epoveda_ac
New Contributor
5 months ago

Reset Password On-Prem User

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

Security
  • IftaqarAhmed's avatar
    IftaqarAhmed
    5 months ago

    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

  • IftaqarAhmed's avatar
    IftaqarAhmed
    New Contributor III
    5 months ago

    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