Forgot your Dynamics GP system password?
They system password is stored in the SY02400 table located in the Dynamics database. It is not recommended to remove or reinsert a record in this table.
Here is a simple script to reset the system password allowing the user to redefine it.
Note: It is highly recommended that you backup your database before trying out these commands or any other scripts.
Script:
UPDATE DYNAMICS..SY02400 SET DMYPWDID=1, PASSWORD = 0x00202020202020202020202020202020
Post your comments regarding to this blog.
Regards,
Natarajan S
They system password is stored in the SY02400 table located in the Dynamics database. It is not recommended to remove or reinsert a record in this table.
Here is a simple script to reset the system password allowing the user to redefine it.
Note: It is highly recommended that you backup your database before trying out these commands or any other scripts.
Script:
UPDATE DYNAMICS..SY02400 SET DMYPWDID=1, PASSWORD = 0x00202020202020202020202020202020
Post your comments regarding to this blog.
Regards,
Natarajan S
Thanks for this... its helped me a lot....
ReplyDeleteso 3 years since your post and you save dme big tim. Thank you very much had spent a long time troubleshooting this and you saved me longer
ReplyDelete