Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

This login failed. Attempt to log in again or contact your system administrator

Posted on by 5

Hi 

Recently my company Old Microsoft Dynamics GP windows server 2012 r2 migrated new Server windows server 2016 OS.

 

The GP users are local SQL account users.As per the Microsoft article SQL login and password Transfer logins and passwords between instances of SQL Server.

https://docs.microsoft.com/en-us/troubleshoot/sql/security/transfer-logins-passwords-between-instances

 

Now all the users facing This login failed. Attempt to log in again or contact your system administrator
 8715.gp.png

Categories:
  • CU15050559-0 Profile Picture
    CU15050559-0 2 on at
    This login failed. Attempt to log in again or contact your system administrator
    thanks for sharing the Office Ally information
  • Abubakkar Profile Picture
    Abubakkar 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Hi Bill

    Thanks for your effort and support.

    Above error its not related ODBC issue.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,645 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    As Richard notes the major cause of this can be the ODBC connection. 

    If you are moving from an older ODBC version - problem.  
    If you have the same version - but you create the ODBC Connection with a different NAME - then same problem.

    So you might have 'imported the SQL logins per the script provided, but you may a difference in ODBC.

    If you already covered this - sorry - just jumping in to put my two bits into the conversation.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    The problem is in SQL. How many users are we talking about? Can you delete all the users in GP and then go into SSMS and remove these users from the DYNAMICS and all company databases.Go into GP and add these users back. If this is not possible pick one user and drop that user from DYNAMICS and all company databases. Then add that user back to the DYNAMICS database and then go to Tools->Setup->System->User Access click on each company. Make sure this user has been granted the DYNGRP role.

  • Abubakkar Profile Picture
    Abubakkar 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Hi

    i really appreciate your quick response

    yes. I can login any workstation with sql sa account its working fine, If i tried any users account the same error.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    On one of your workstations, login as 'sa' Does this work? If so, set the user's password on this workstation and then try logging into GP as this user. You may have different versions of the ODBC driver so the password get encrypted differently.

  • Abubakkar Profile Picture
    Abubakkar 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    You are correct. but as per Microsoft  refer transfer the logins and the passwords between different instances of SQL Server running on Windows.

    docs.microsoft.com/.../transfer-logins-passwords-between-instances

  • Abubakkar Profile Picture
    Abubakkar 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    No you are wrong. Its not only one users all users around 30 to 40 users. How its possible all users incorrect password.

  • Abubakkar Profile Picture
    Abubakkar 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    Thank . will check,  i will update you.

  • Daemonk Profile Picture
    Daemonk 5 on at
    RE: This login failed. Attempt to log in again or contact your system administrator

    The most common cause of this error is that the user has entered the incorrect User ID or Password. It is important to note that both the Dynamics GP User ID and Password are case sensitive. Unfortunately, the GP system error does not indicate which field has been entered incorrectly. It may be the User ID or the Password or Both.

    mcdvoice survey

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans