Note, this tip is for GP Administrators only. Attempts by non-administrators to change the system password could compromise data security!
Occasionally, the GP system password is forgotten or lost. This password is required to make changes at the system level, such as adding a new user, changing user security, etc. Here's how to recover when this happens.
1. In SQL Management Studio, run this script to remove the existing password -
UPDATE DYNAMICS.SY02400
SET PASSWORD = 0x0202020202020202020202020202020
2. In GP, reset the system password.
Tools>Setup>System Password
* click image to enlarge
Now, store the password in a safe, accessible place!!
5 comments:
Hi Frank,
This may pose a threat to System Security as those who have access to SQL would reset this and may take advantage of it.
I think it's better we do not share this specific information.
Or at least it's better we add a NOTE stating that this is strictly for Administrators.
Vaidy
Great point Vaidy but presumably, only administrators would have access to SQL, right?
Yup, very true Frank. But we never know, how it could be misused.
Probably I am bit more concerned about Security !?!?! :-)
Vaidy
Hmmm, and probably I'm not concerned enough Vaidy! Thank yoiu for your valuable input.
Thanks Frank. This worked great!
Post a Comment