how to get or reset the password for DYNSA

Posted on 2010-08-30
Last Modified: 2013-12-11
We have microsoft dynamic GP version 9.1 and planning to upgrade it to the latest versin 10 but the person who had installed it 3 years back is not more with us and he also forgot the DYNSA credentials.
Can anyone help me  and guide me how can i get or reset the DYNSA credetials.
Question by:pdixit1977
  • 3
  • 2
LVL 18

Expert Comment

by:Steve Endow
ID: 33560005

If you have the "sa" login, you can login to Dynamics GP as sa, then open the User window (Tools -> Setup -> System -> User) and reset the DYNSA password from within GP.  This would be the recommended method.

Technically, you can also *change* the password through SQL Server Management Studio.  Under Security folder -> Logins, right click on DYNSA, go into Properties, and then change the password.  Then launch GP and login as DYNSA using that new password.  GP should detect that the SQL password is not encrypted using GP's encryption mechanism, and should then prompt you to reset your password.  Enter the 'old' password you used in Management Studio, then type a new password.  GP will then encrypt the password and reset the SQL login password.  This usually works, but depending on the SQL Server client driver you have installed, there could be complications with this approach (which I have seen), which is why resetting the password within GP is recommended.

Let me know if that works for you.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional


Author Comment

ID: 33560361
Unfortunately we also dont have "sa" password with us and keeping its criticality in mind i dont want to do anything which is not recommended or could create problems.

Please advice..
LVL 18

Accepted Solution

Steve Endow earned 250 total points
ID: 33560631

In that case, your bigger problem is not the DYNSA password, it's the sa password.  You will want at least one person at your organization to know the sa password.  You shouldn't need it in day-to-day operation of GP, but you will need it for some system maintenance processes, or setting up new users in GP.

To reset the sa password, you can login to your SQL Server with a local Administrator windows login.  You will want to do this after hours, and preferrably on a day when you have time to deal with any issues that may be caused by the password change.

Once you are logged into the server as an Administrator, launch SQL Server Management Studio and select Windows authentication, which should allow you to login to your GP SQL instance.  

Once you are connected to the SQL Server, go into Logins and reset the 'sa' password.  You can then login to GP as 'sa' and reset the DYNSA password.

Once you change the sa password, it can cause certain things to temporarily stop working, such as SQL backup jobs or external integrations or reporting that relied on the sa password.  I would recommend identifying those, and then setting up separate, dedicated logins for those processes.  Ideally, you should be able to reset the sa password and not affect anything else, and conversely, nothing else should rely on the sa password.

If you do not have an Windows Administrator account to login to your server, then that is another problem that we'll have to figure out or work around.

And if you are not comfortable with this process, I would recommend that you get in touch with your GP partner and have them assist you with this process (they will probably bill you, but you can get an estimate first).  It should be very simple for them, and will likely save you time and anxiety if you are not familiar with the process, and they can show you the process.  Or you can probably setup a paid support case with Microsoft Business Solutions support, and they can walk you through the process.

Let me know what you think or if you have additional questions.


Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional


Author Comment

ID: 33560786
we have local admin credentials since i have domain admin previledges on my ID. Let me check it and let u know.

Author Closing Comment

ID: 33671487
However i still did'nt do it but it seems logical. thanks for help

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now