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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

615 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