Microsoft Dynamics GP (Archived)

GP SYSTEM PASSWORD

(0) Share

Report

Posted on by Peter Muchira

1,912

Hi there. How can one edit when GP prompts for the SYSTEM PASSWORD ??

Regards,

Peter Muchira

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Heather Roggeveen 9,146 on at

Like (0)

Report

I don't think you can. You could however consider changing the system password to blank (then it doesn't ask) and controlling access to the windows via security.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Heather is correct as you can change the password but you first must know it. You can go to Micorosoft Dynamics GP | Tools | Setup | System | system password and change it there. If you enter in nothing the password will be blank and you will not be prompted.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Now, if you don't know the password, then there is light at the end of the tunnel for those that have the following scenario: "I am new here and the last DBA left the company and never give up the system password"

Note: its not the sa password, but to blank the system password, which requires access to SQL

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

I would not recommend blanking the password in SQL as that can cause some serious issues. If you don't know the system password please open a support case so we can decrypt it.

Thanks

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

There is a simple way of obtaining the GP system password w/o wasting a support case. If you want, I could remote to your computer and show you how to get it.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Richard if you are referring to blanking out the password in the table or updating the record for the password I need to recommend that you do not do this as it can cause issues (which I have seen first hand).

Thanks.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Nope, there is a very simple way to find out what the GP password is. If you want to send me an email I will explain how it is done.

Was this reply helpful? Yes No
Heather Roggeveen 9,146 on at

Like (0)

Report

Richard - I would be interested to know if you can send me an e-mail.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

David Musgrave posted this solution on his blog years ago. A simple search of the internet will reveal what I have used for years. I have been using Dynamics GP since it first came out on 48 floppy disks. This is no big secret.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Here is the easy way to reset the password if you dont know it. Assumes that you have Power User role.

1) MS Dynamics GP > Maintenance > SQL

2) Database = DYNAMICS, Product = MS Dynamics GP

3) Select System Password Master as the table

4) Drop the table (that deletes the table)

5) Create the table (recreates the table with a blank password)

You now should be able to proceed to system functions, including establishing a new password.

Warren

Was this reply helpful? Yes No