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...
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