If you’d like to watch the video that goes with this article, see below or click here.
After installing SmartPost, when logging into Microsoft Dynamics GP as the SmartPost user, I get the error message
Login failed for user ‘SmartPost’
Ordinarily, this shouldn’t happen because when I installed SmartPost, I made sure to enter the same password as the password for the SmartPost user I created in Dynamics GP, which is a PowerUser role.
Why do I get an error for user ‘SmartPost’ when I can log into GP as that same user with the correct password?
User ‘SmartPost’ Fix
The problem is the SmartPost user should NOT be a GP user. It is an “internal” SQL Login that the smartpost install creates and shouldn’t be created in GP as was done here.
The reason the login fails is because the GP login is encrypted, and in SQL, it is not whatever was entered into the GP User install. Because the SmartPost installer uses that password as plain text, the passwords don’t match and the login fails.
The solution to this issue is to delete this GP user so that the login is deleted. If you want to make a specific “smartpost” GP login, call it anything but SmartPost.
Now re-install SmartPost again, and this time the smartpost login will work and SmartPost will connect correctly.
If you are still having login issues, please contact us so we can help troubleshoot the problem.
