You’re offline. This is a read only version of the page.
930
Good afternoon
I'm the sysadmin here in the office and in my PC (in forward WS1) I set the passwords for each GP user but when he will login in his PC (in forward WS2) the password doesn't work. So, I need to login in GP with my poweruser on his WS2 and set the password directly in WS2 to be fine to work. But this is not desirable.
Do you have any clue about why if I set a GP user password (using my poweruser or 'sa' ) in my PC (WS1) it doesn't work in user's PC (WS2) ??
thanks in advance
HB
It is possible, yes.
Specifically, the encryption of GP user passwords is setup per the server name in the DSN, so if they are different on two machines, such as your server and PC, it can cause this to not work.
Again, to verify this, reset the user's password in Dynamics GP on the server and verify they can login. If they can, have them then attempt to login on the PC.
If they cannot login to the PC, but can login on the server, reset their password in Dynamics GP on the PC, then verify they can now login to GP on this PC. If they can, have them try logging into GP back on the server again.
If they now cannot login to GP on the server, then it's most likely what you're running into.
Based on the comments from both Richard and Derek I would agree that the difference in these ODBC connections will cause a problem with the hashing of the Password. I have found that missing a 'space' or having an extra 'space' in the name of the ODBC can lead to this behavior.
This was especially true with Integration Manager and or Management Reporter - I have been sure to keep the ODBC the same on all machines for many years now.
woao, ok, in my case, we are using on workstations a "DNS alias" but in the Server's OBDC we use the hostname directly, this different may cause this bevahior?
Richard is correct. Also, if the ODBC DSNs on all machines are not setup identically, what will happen is the GP user's passwords will be encrypted differently, thus, if you reset the user's password on workstation #1, that user will be able to login to GP on that workstation but maybe not workstation #2.
Resetting the user's GP password on workstation #2, then breaks the user from being able to login to GP on workstation #1.
The ODBC DSN is looked at when encrypting user's passwords, so if they're not setup identically, they'll cause the above behavior to occur.
Thanks
There are different versions of the SQL Data Client being used. Check your ODBC connections.
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...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (