Announcements
I am at a complete loss and almost feel foolish for asking this question but all of a sudden 1 user cannot log into the DEV environment. I have verified that the SQL Account is not locked out - He does not use the Enforce Password Policy option in GP or SQL - I have reset his password multiple times, even changing it in SQL then in GP and his user, which is Active cannot log into GP.
Are you able to log in as sa on the workstation? Have you tried removing the password via SQL Management Studio (not just changing it) so that the user logs in without a password and is then prompted to change it. (This helps with quirky encryption stuff)
Here is a tech document on the message:Error message when you try to log on to Microsoft Dynamics GP: "This login failed. Attempt to log in again or contact your system administrator"
Agree with Lisa,
99% of the time it's an ODBC issue as described in the KB article from the link.. The Server's ODBC connection is different from the one on the user's computer and then the password gets encrypted with a different key (SQL server name in the ODBC must match in order to work).
I would log onto this workstation as 'sa' and then set the user's password. Then have the user logon on to the same workstation. Most likely there is a different version of the SQL Native Client.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 341 Most Valuable Professional
CU10121822-0 312
André Arnaud de Cal... 262 Super User 2026 Season 2
