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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dynamics CRM Online: Add Button on Sub-Grid 8 345
crm 2016 on cloud 5 89
TFS - Rolling back to a previous release / CRM 2011 8 117
User Account Control Message for Sage 50 3 212
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

11 Experts available now in Live!

Get 1:1 Help Now