"Login failed for user '[User Name]'" Error message when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0
This article provides a solution to an error that occurs when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0.
Applies to: Microsoft Dynamics GP
Original KB number: 941457
Symptoms
When you run the UserInfoGet.CreateADOConnection Visual Basic for Applications (VBA) function in Microsoft Dynamics GP 10.0, you receive the following error message:
Login failed for user '<User Name>'.
Note
In this error message, User Name represents the actual user name.
Cause
This problem occurs if the user name differs from the user identifier (user ID).
For example, the user name is John Doe, but the user ID is JDoe. In this case, the UserInfoGet.CreateADOConnection function tries to authenticate with an instance of Microsoft SQL Server by using the user name of John Doe. However, the user ID that is created in Microsoft SQL Server is JDoe.
Resolution
To resolve this problem, obtain the latest service pack for Microsoft Dynamics GP 10.0.
Workaround
To work around this problem, update the user name to be the same as the user ID. To do it, update the value in the User Name field in the User Setup window to match the value that is in the User ID field.
Status
Microsoft has confirmed that it's a problem in the Microsoft products that are listed in the Applies to section. This problem was first corrected in Microsoft Dynamics GP 10.0 Service Pack 1.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for