Hi
Recently my company Old Microsoft Dynamics GP windows server 2012 r2 migrated new Server windows server 2016 OS.
The GP users are local SQL account users.As per the Microsoft article SQL login and password Transfer logins and passwords between instances of SQL Server.
https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances
Now all the users facing This login failed. Attempt to log in again or contact your system administrator
Hi Bill
Thanks for your effort and support.
Above error its not related ODBC issue.
As Richard notes the major cause of this can be the ODBC connection.
If you are moving from an older ODBC version - problem. If you have the same version - but you create the ODBC Connection with a different NAME - then same problem.
So you might have 'imported the SQL logins per the script provided, but you may a difference in ODBC.If you already covered this - sorry - just jumping in to put my two bits into the conversation.
The problem is in SQL. How many users are we talking about? Can you delete all the users in GP and then go into SSMS and remove these users from the DYNAMICS and all company databases.Go into GP and add these users back. If this is not possible pick one user and drop that user from DYNAMICS and all company databases. Then add that user back to the DYNAMICS database and then go to Tools->Setup->System->User Access click on each company. Make sure this user has been granted the DYNGRP role.
i really appreciate your quick response
yes. I can login any workstation with sql sa account its working fine, If i tried any users account the same error.
On one of your workstations, login as 'sa' Does this work? If so, set the user's password on this workstation and then try logging into GP as this user. You may have different versions of the ODBC driver so the password get encrypted differently.
You are correct. but as per Microsoft refer transfer the logins and the passwords between different instances of SQL Server running on Windows.
docs.microsoft.com/.../transfer-logins-passwords-between-instances
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,317
André Arnaud de Cal... 918 Super User 2025 Season 2
Sohaib Cheema 656 User Group Leader
