Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Only sa login is working to login to GP 2016

(0) ShareShare
ReportReport
Posted on by 5

I have a SQL 2016 server running GP 2016 16.00.0864 (r2)

On the server all GP logins work normally.

From a client computer only "sa" works, all others fail without regard to Role.

Categories:
  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,932 Most Valuable Professional on at
    RE: Only sa login is working to login to GP 2016

    You might find this article helpful

    https://winthropdc.wordpress.com/2008/10/01/why-does-microsoft-dynamics-gp-encrypt-passwords/

    Also you can use GP Power Tools - Database Validation tool to reset all passwords.

    Regards

    David

  • Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Only sa login is working to login to GP 2016

    Tom,

    What this means is that your ODBC connection string is different on the server and on the workstation, which is not a good thing.. technically it should be identical everywhere to avoid exactly this type of issues..

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Only sa login is working to login to GP 2016

    Encrypted passwords are a wonderful thing.

  • Tom Griffin Profile Picture
    Tom Griffin 5 on at
    RE: Only sa login is working to login to GP 2016

    So simple and yet eluded me completely.

    Thanks, Richard

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Only sa login is working to login to GP 2016

    Go to one of your workstations. Log into GP as 'sa' and set a user's password. Then try to login as this user on this workstation.

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans