GP #LifeHacks 113: Resetting Forgotten System Password

Some of the administrator type functions in Dynamics GP use a system password in order to provide a thin layer of protection against unintentional and/or inappropriate use.

This password often gets misplaced, forgotten, or just disappears with turnover.

I have some good news for you if you fall into this situation… A SQL Script can be used to reset the password.

Resetting the System Password

I feel compelled to share that this is NOT the SA password… that is something very different.

Run the script below.  This will make the system password ‘blank’ allowing you to go into GP and reassign a system password.  Be sure to take the appropriate precautions (backup, backup, backup!) before running the script below, it never hurts to have a backup. 🙂

  • UPDATE DYNAMICS..SY02400 SET DMYPWDID=1, PASSWORD = 0x00202020202020202020202020202020

Navigate to ‘Administration/Setup/System/System Password’ in order to find the system password window.

After resetting it to blank, you can simply put in the new password.  Do yourself a favor, keep it in a safe place – and no… not on a sticky under your keyboard 🙂

Thanks for reading!

Shawn


Shawn Dorward

Microsoft MVP, Business Solutions

GPLifeHacks.com| LinkedIn | Twitter | GPUG | MSDYNGP

Original Post:
https://gplifehacks.com/2018/03/17/gp-lifehacks-113-resetting-forgotten-system-password/

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.