Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


how to get or reset the password for DYNSA

Posted on 2010-08-30
Medium Priority
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 1000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

If you need to import sales transactions from another system into Microsoft Dynamics GP as Sales Order Invoices, you may need to store some additional data related to the customer, the transaction, or the line items.  Even if your company is manuall…
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.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

722 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