I occasionally get a call from a customer who is having trouble logging in to Dynamics GP. They created a new user, they know they have the password correct, but GP keeps saying the login failed.
If you encounter this issue, one of the things to check is the capitalization of the GP user ID.
My login failed when I used "testuser". Notice that the User ID is actually "TestUser".
Unlike the rest of the software world, Dynamics GP user IDs are case sensitive. So whenever you have a puzzling login failure, try checking the capitalization of the user ID.
Steve Endow is a Microsoft MVP
for Dynamics GP and a Dynamics GP Certified IT Professional in Los Angeles.
He is the owner of Precipio Services, which provides Dynamics GP
integrations, customizations, and automation solutions.
Steve,
ReplyDeleteGood post. I believe this is due to the user name being one of the keys for the encryption of passwords.
Perry
Oddly enough SQL collation would also dictate if a system object like a user name would be case sensitive as well.
ReplyDeleteJonathan,
ReplyDeleteWe shall not speak of the SQL Collation that shall not be named!
Steve