Solved

how to get or reset the password for DYNSA

Posted on 2010-08-30
5
2,332 Views
Last Modified: 2013-12-11
Hi,
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.
0
Comment
Question by:pdixit1977
  • 3
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Steve Endow
ID: 33560005
Hi,

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.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional


0
 

Author Comment

by:pdixit1977
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..
0
 
LVL 18

Accepted Solution

by:
Steve Endow earned 250 total points
ID: 33560631
Hi,

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.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional


0
 

Author Comment

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

Author Closing Comment

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

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), 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…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

743 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

16 Experts available now in Live!

Get 1:1 Help Now