Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Login issue Dynamics GP 2015

Posted on by 30

I inherited a system and I am trying to login to Dynamics 2015. Checked the ODBC connection and it passes the test. I don't know any account that can login. I went into SQL and changed the password to the DYNSA account and set the account to sysadmin. Prompts it can't login to contact system admin. The password is under 15 characters. I fear changing the SA account password due to messing up any other system or anything that might be dependant on that password for something. Even if I do wouldn't the DYNSA account work the same if its set as a sysadmin?

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Login issue Dynamics GP 2015

    kcranmer, I am with Richard on this one - it is not just changing the password for SA to get into GP, it is the other services or tasks that are using SA to access the data - not a best practice, but lets face it - it happens all the time.

    Another option would be to create a SQL User - cranmer - and make it a sysadmin just as SA - make sure it has access to the Dynamics and Company DB's just as SA would - then use that to login to GP 

    Once in GP - create yourself a 'poweruser' and then make the password changes for the other users.

    I have had to do this in the past where I have IT team that owns the SQL Server and will not give up the SA password - so I make my own admin account.  Then we are all happy

    Hope this, along with Richards suggestions brings you to a successful solution.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Login issue Dynamics GP 2015

    That is a tough call. Do you have any other services or applications that use the 'sa' password? If you log into SSMS using windows credentials and change the 'sa' password you will be able to go into GP as 'sa' and reset the DYNSA password.

  • kcranmer Profile Picture
    kcranmer 30 on at
    RE: Login issue Dynamics GP 2015

    I don't know the SA password and fear changing it. If I change it in SQL it will for sure let me in?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Login issue Dynamics GP 2015

    Never change the password in SQL and expect the password to work in GP. Log into GP as 'sa' and then change the DYNSA password using GP.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans