January 20, 2010

gptip42day - Resetting the GP system password


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:

  1. UnknownJanuary 20, 2010 at 11:21 AM

    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

    ReplyDelete
  2. Frank HamellyJanuary 20, 2010 at 11:55 AM

    Great point Vaidy but presumably, only administrators would have access to SQL, right?

    ReplyDelete
  3. UnknownJanuary 20, 2010 at 12:11 PM

    Yup, very true Frank. But we never know, how it could be misused.

    Probably I am bit more concerned about Security !?!?! :-)

    Vaidy

    ReplyDelete
  4. Frank HamellyJanuary 20, 2010 at 12:47 PM

    Hmmm, and probably I'm not concerned enough Vaidy! Thank yoiu for your valuable input.

    ReplyDelete
  5. KevinJune 12, 2013 at 4:40 PM

    Thanks Frank. This worked great!

    ReplyDelete