I forgot my r9 mart administrator password. How can I recover that? (4311287)

Description:

I forgot my r9 mart administrator password. How can I recover that?

Solution:

Please follow the steps.
1. Stop MartServer.
2. Create new Test Database.
3. Configure Mart with Test Database.
4. Create MartAdmin with same username as the other mart admin whose password needs to be recovered.
5. Put password as "Erwin123".
6. Go to Sql Server Use Test Database tables. Right click on m9User, click on edit top 200 rows.
7. Copy the encoded password of the user and paste it in notepad.
8. Stop MartServer.
9. Configure MartServer with the original Mart Database.
10. Go to Sql Server, use original Mart Database tables. Right click on m9User, click on edit top 200 rows.
7. Copy the encoded password of the user and paste it in notepad.
8. Replace the encoded password with the one which we saved on step 7 or use the 
Update m9User set Password = 'step 7 pasted password'
where Userid=1 
9. Start MartServer.
10. Start Mart Admin, login with mart admin username and password "Erwin123".

For r9.7 mart 

Please execute the below query using your query tool and let us know if that resets the password to "Erwin123" for the user 'admin'.

Update m9User set Password = 'f8b9ab44a365a22bb0dfb71f9bb9abb011f12c430372f5f784be84c82e86473c'
where Userid=1  ( or whichever is the userid for the administrator login)

This is the quickest way to recover.  

In general. the default “erwin” password has been as follow, but it can change with different versions. You can try it as a shortcut, but if this does not work, please try the steps as detailed above.  

f4c46e37623dcb45c898e7de0269c82d0cce6148fec673e29b3e053e4740d7ab

Update m9User set Password = 'f4c46e37623dcb45c898e7de0269c82d0cce6148fec673e29b3e053e4740d7ab'

where Userid=1 ( or whichever is the userid for the administrator login)

NOTE:  if it’s a brand new mart, just drop the database owner, recreate the mart and start from scratch. That is a way you could take action right now IF there is no data in the mart you want to preserve.  If there is data in the mart you want to preserve, don’t do that.