Recovering the System Menu Password in Dynamics GP

| 05/16/2010 | 4 Comments

Hi all

How many times have consultants faced the situation where the system menu password in Dynamics GP is forgotten? This typically happens when we return to a client for an upgrade after about a year and it happens to be the case where the client side admin has forgotten the password as well… :)

Most of the time we handle this by deleting the record from the System Password Master table (SY02400) and then re-defining the password once more. But is there a way to recover the existing password without manipulating the data at SQL level? Fortunately, we do have an alternate solution and I am going to elaborate on the steps to recover this password, in this article.

When you have logged into Dynamics GP, go to Microsoft Dynamics GP >> Tools >> Customize >> Report Writer and choose the product as Microsoft Dynamics GP. This will open GP in the Report Writer mode as shown below. Click on the Reports button in the Toolbar.

image  image

Click on the New button in the Report Writer window and enter the following details for the new report that you have decided to create.

Report Name System Password Master
Series System
Main Table System Password Master
Using Key SY_System_Password_Key1

The report definition window would look as shown below.

image

Now click on the Layout button. Add the Password field from the System Password Master table into the Body section of the report as shown below.

image   image

Close the report and choose Save on the prompt that shows up.

Click OK on the Report Definition window to close the report definition window as well. Now you should be noticing the new report that we had created in the Report Writer window as shown below.

image

Select the new report that we had created and click on the Print button. On the Report Destination window, choose to print the report on Screen and click on the OK button.

The report will print on the screen and it will display the decrypted system menu password on the report as shown below.

image

Note: Note that in order to create this recovery report, we need to have access to this system series table, which is only available to users having the POWERUSERS role. Thanks to David Musgrave for providing this information.

This is an alternate method for GP administrators to recover the system menu password without having to delete the System Password Master table and resetting the password. Hope this article is helpful to all. :)

Until next post…

VN:F [1.9.22_1171]
Rating: 10.0/10 (5 votes cast)
VN:F [1.9.22_1171]
Rating: +3 (from 5 votes)
Recovering the System Menu Password in Dynamics GP, 10.0 out of 10 based on 5 ratings

Tags: , , ,

Category: Dynamics, Great Plains, System

About the Author ()

  • Pingback: Mohammad R. Daoud

  • Pingback: Recover “Not Reset!” the System Password!?!?!?!?!?! - Mohammad R. Daoud

  • veeyeskay

    Thanks for the valuable comments David. I have updated my post with your comment. :)

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)
  • http://blogs.msdn.com/DevelopingForDynamicsGP/ David Musgrave

    Please note that you will not be able to use this method unless the user already has access to the System Password Master table, which would be denied to all but POWERUSERS by default.

    VA:F [1.9.22_1171]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.22_1171]
    Rating: 0 (from 0 votes)