Tuesday, August 30, 2011

Recovering from a lost MASTER password

Recovering from a lost MASTER password

If you have lost the MASTER password for Maximizer, here’s how you can reset it. This procedure can also be helpful if the saved password gets corrupted and you receive a second login prompt each time you open the address book.

Launch SQL Server Management Studio and connect to SQL Server using Windows Authentication. (If you are running the Enterprise Edition of Maximizer and SQL Server Authentication is enabled then you could also connect as ‘sa’.)

Click on the New Query button to open the Query Window.

First, reset the password for the MASTER login, after each line click the execute button above the Query window to execute the command.

ALTER LOGIN MASTER WITH PASSWORD='CONTROL'

Next, remove the encrypted MASTER password that is stored in the database itself. Remember to change the database name in the USE statement to match the name of your address book database

USE EsconaTutorial
UPDATE dbo.ADMN_Users1 SET [Password]=''
WHERE Record_Id IN
(SELECT Record_Id FROM dbo.ADMN_Users
WHERE User_Id='MASTER')

Now launch Maximizer and log into the address book as MASTER using CONTROL as the password. You will be presented with a dialog that says

Your Maximizer user password seems to be different from your SQL login password. Therefore you will be asked for your Maximizer user password now.

At the second login dialog, just leave the password empty and click “OK”. Once in Maximizer, choose

Setup > Manage Users

select the MASTER user and click the “Password…” button. In the Password dialog, leave the “Old password” box empty and enter a new password into “New password” and “Confirm password”. If you are prompted to change the password in all other Maximizer databases, click “Yes”.

Maximizer will close the address book after the password change is complete. Now re-open the address book as MASTER using the new password.

4 comments:

  1. Found this post at 11 PM on a Friday night. Worked perfectly. Thanks.

    ReplyDelete
  2. It is important to use an ALL CAPITAL password as the SQL server password. Maximizer appears to convert all passwords to capitals.

    ReplyDelete
    Replies
    1. This comment has been removed by the author.

      Delete
  3. All seemed to be going well but after executing third command query failed with following .....

    Unclosed quotation mark after the character string ''.
    Msg 102, Level 15, State 1, Line 1
    Incorrect syntax near ''.

    Subsequent commands seemed to execute OK, but leaving the Maximizer password empty didn't work, indicating that the encrypted MASTER password has onvioulsy not been removed during carefully entered instructions.

    Suggestions please??

    ReplyDelete