Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0: "Login failed for user '[User Name]'"

Error message when you run the UserInfoGet.CreateADOConnection VBA function in Microsoft Dynamics GP 10.0: "Login failed for user '[User Name]'"

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.

↑ Back to the top

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."

↑ Back to the top

Resolution

To resolve this problem, obtain the latest service pack for Microsoft Dyanamics GP 10.0. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer.

Partners
https://mbs.microsoft.com/partnersource/products/GreatPlains/downloads/servicepack
Customers
https://mbs.microsoft.com/customersource/support/downloads/servicepacks

↑ Back to the top

Workaround

To work around this problem, update the user name to be the same as the user ID. To do this, update the value in the User Name field in the User Setup window to match the value that is in the User ID field.

↑ Back to the top

Status

Microsoft has confirmed that this is 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.

↑ Back to the top

Keywords: kbnosurvey, kbexpertiseadvanced, kberrmsg, kbmbspartner, kbexpertisebeginner, kbtshoot, kbmbsmigrate, kbbug, kbexpertiseinter, kb

↑ Back to the top

Article Info
Article ID : 941457
Revision : 1
Created on : 3/13/2017
Published on : 1/13/2015
Exists online : False
Views : 107