Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

This login failed. Attempt to log in again or contact your system administrator

Posted on by Microsoft Employee

A colleague reported a strange problem. She had been asked to add a new user to GP. She did the usual things, added the user in GP, set a password, granted access to a company. Granted security to the user and company and added the role.  She then tried to log in as the user to test. She logged out of GP as the sa user and logged in with the new user and password. She then got the following error. "This login failed. Attempt to log in again or contact your system administrator". We changed the password several times, verified that password. Created a password in notepad and pasted it into the two password fields. We also verified the corresponding login was being created in SQL. 

This client environment is hosted in Azure and the users login via a RDS Portal front end before launching the Dynamics GP client. As I had to create the domain account, for the user, I then decided to test the RDS Portal. This time when they launched GP and entered the password, the connection was made and GP successfully opened. We then went back to the desktop, which is the same server that the RDS portal is on and again got the login failed. 

Does anyone have any idea as to why it would work through the portal, but not through the desktop GP icon? This is more of a mystery than a real problem as the user will never be logging in via the desktop icon.

Thanks

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Have you tried to delete this user from GP and go into SSMS and delete all references to this user and then try again? You could also try using a different GP user name.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    We are using the same desktop. I can log in as sa and change the password. However when I log out and log back in, I get the error message. It is the same ODBC so not an issue caused by encryption. Also I do not have a default database selected so this also is not the issue. It is a strange issue and currently unexplained. 

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Also check the default database in the ODBC settings between the two.

    Tim.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Go to the desktop and login as 'sa' there and set this user's password. Then try having this user login on the desktop.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans