Resetting forgotton Administrator Password

Only 3 tier MicroStrategy metadata that I can run a SQL query is client’s 😥

Looking forward for people who can execute the following SQL statement directly against the MicroStrategy metadata. Perfectly legal and DMCA compliant as encryption is not broken but bypassed.

UPDATE  DSSMDUSRACCT
SET PASSWD = ‘00000000c34abc5741b1cf54247cbc76af3b513ec911585a22b95befb7e10c14’
WHERE upper(LOGIN) = ‘ADMINISTRATOR’

If above given password doesn’t work use any of following:

9c1185a5c5e9fc54612808977ee8f548b2258d31
00000000187c9eeace8a9d2b94b7b8c21d4e1d10c911585ad5674d244057eb6f

It may be very foolish of me trying to bypass the RMD 160 encryption 😀 . I don’t even know if it works. Basically the above given SQL statement rests the password to “” (nothing). As I do not have any easy access, please let me know if it works for you. You may have to change the SQL syntax of the DBMS in which your metadata is stored.

Note: I’m not responsible if your metadata is redundant due to use of the above SQL statement or use of above statement bring you issues at your job. Also, this would work only in a metadata NOT having used  in 2 tier configuration prior to execution of SQL statement. ie, you must connect to the metadata using a 3 tier connection before execution.


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399

One thought on “Resetting forgotton Administrator Password

  1. Hi Ashish,
    It’s not working. My MD is running on oracle and two tier mode. when i try to register as 3 tier, it could not happened because of i lost Administrator password. it would be great if you share your thoughts.
    but, your effort should be appreciated.

Comments are closed.