You’re offline. This is a read only version of the page.
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
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.
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.
Also check the default database in the ODBC settings between the two.
Tim.
Go to the desktop and login as 'sa' there and set this user's password. Then try having this user login on the desktop.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,524
Super User 2024 Season 2
#2
Martin Dráb
228,469
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (