Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

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

  • 1.  User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 05-24-2018 02:10 PM
    ​​Hi There,

    We have some user login issues reported this week. The users claim that they are using the right passwords but they are not able to get into GP.

    I reset their passwords and try to login as the user myself to check if it works and strangely GP doesn't allow the login.  I got the same error even with the new reset password. I deleted the old user id and created a new one and it worked.
    This is the second case this week.  Has anybody faced this issue ?


    Thanks,
    Mangala

    ------------------------------
    Mangala Shetty
    Saint Elizabeth
    Markham AB
    ------------------------------


  • 2.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 05-25-2018 07:22 AM
    Hi Mangala,
    Do you reset the pwd on the same system where you test it afterwards ?
    If not, could it be that your ODBC connection doesn't have the same instance name on the different computers ?  this is a fairly common issue where someone setup the GP client by using a different SQL server name (i.e. using IP Address instead of canonical name), and since GP uses that instance name to encrypt the password in the database, the pwd does not match when connecting from another computer.
    If it's on the same computer, then there is something else that plays in the game, but it could be an issue with the Firewall or network.
    Is it a single user that faces the problem or did it happen to several ?

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 3.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 05-25-2018 10:45 AM
    ​Good Morning Beat,

    Yes, I reset the password on the same system and I test it on the same system afterwards. It doesn't work. When I delete the ID and recreate the same ID, it works.
    It happens to some 4-5 users only. This week I deleted all of their user ids and recreated them and observing if that fails as well. One of them failed today and I did the same thing - deleted and recreated!

    Thanks,
    Mangala

    ------------------------------
    Mangala Shetty
    Saint Elizabeth
    Markham AB
    ------------------------------



  • 4.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 05-28-2018 09:06 AM
    Thanks Mangala for the reply.
    This is going to be hard to debug when such thing happen randomly... There could be a lots of parameters involved, like not using the same SQL Client version on the workstations, or the SQL server collation, or an inconsistent ODBC connection name..
    How do the user access GP ? local clients or Citrix / TS environment ?
    Are you using "enforced user policy" when defining the pwd on the GP side for the users ?

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 5.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 05-28-2018 10:55 AM
    ​Good Morning Beat,

    Thank you for the response. The issue is in Live environment. The users access GP through a TS environment - Workspot, and we check the box for the "enforced user policy" while defining the password on the GP side.

    Thanks,
    Mangala

    ------------------------------
    Mangala Shetty
    Saint Elizabeth
    Markham AB
    ------------------------------



  • 6.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 05-29-2018 08:34 AM
    Workspot ?
    Uh Oh..  I can already see a problem here.. this is a cloud based solution that allows for remote access of GP that would be stored on an Azure platform ?..
    It's hard to tell, since we don't know much about the environment and how it was setup.. Where is the GP server / databases ? how do the users access the "Workspot"  session ? are they using a full desktop login or only a published app login ?
    The type of issue your users are facing seems related to the fact that the server names seems to change randomly and the ODBC connection doesn't stick, which would cause randomly the password to not decrypt correctly anymore..  Based on the marketing paper from Workspot, it looks like that application deployment is made in way to take advantage of Azure regional servers, which can change over time.


    You want to make sure with your provider that the GP client always uses the exact same ODBC connection name that was used in the initial configuration and doesn't change over the course of time.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 7.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 05-30-2018 04:18 PM
    Sorry Beat, took a while for me to get the answers for the below from our Network team.

    Here is what I got;
    We use RDS Remote App solution for Application delivery  - MS Remote App. We are not using the cloud based offering for workspot. We are actually hosting it at our on premise DC.  We do not use Azure.

    Server names do not change in our environment.

    100% confirmed that the GP client always uses the exact same ODBC connection name that was used in the initial configuration and doesn't change over the course of time – There is an RDS server exclusively for the GP environment.

    These issues didn't occur for the previous version of GP (before GP 2016) which was hosted the exact same way that GP 2016 is hosted today.

    Thank you so much really!

    Regards,
    Mangala



    ------------------------------
    Mangala Shetty
    Saint Elizabeth
    Markham AB
    ------------------------------



  • 8.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 05-31-2018 12:39 PM
    Thanks Mangala for providing the details..

    This is very puzzling and strange, as we have been using GP since V 9.0 within a Citrix environment first, and then later Microsoft RDS Terminal Server (for the past 3-4 years) with GP 2013 & I've tested GP 2015, 2016 & 2018 in a cloned RDS site for the past 18months and never had an issue with user authentication..

    What are your 3rd party products that are integrated to GP ? any tools like FastPath or Rockton Toolbox ? GP Power Tools ?

    Does this happen only to specific users or randomly to any GP account ?

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 9.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 06-04-2018 01:50 PM
    ​​Hi Beat,

    True. This is very strange. It is currently happening to 3 users only.  Today one of the user couldn't login, and it worked when I just changed the password, not deleting and recreating the ID. I will keep a close watch to see if it happens again. If yes, as Mark suggested, we may have to  engage GP Power Tools to investigate this issue.
    Currently we have some customized integrations to bring in Accounting and Billing data into GP, nothing related to logins like Fastpath or any other Power Tools.
    I will update you if I find out anything on this issue. Thanks again.

    Regards,
    Mangala

    ------------------------------
    Mangala Shetty
    Sr. Business Analyst
    Saint Elizabeth Healthcare
    Markham ON
    ------------------------------



  • 10.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 06-05-2018 10:23 AM
    Thanks for the follow-up posting.
    I've seen silly things when users would call and say "my GP account is locked out" or "I can't login, my pwd is rejected, but I'm 100% sure about being right"..  and in the end it turns out users had their CAPS lock on and didn't notice, because the LED was so tiny on the keyboard.. (especially on newer laptops).
    Keep me posted on the progress..

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 11.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    Posted 05-25-2018 01:17 PM
    We experience the same issue in our test environment after we have completed a refresh of the database. In order for the user to login to the test company I have to delete the user and recreate their user id. I would be happy to know if someone has a solution to this issue.

    ------------------------------
    George Sheppard
    IT Manager
    Newfoundland and Labrador Liquor Corporation
    St. John's
    ------------------------------



  • 12.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    GPUG ALL STAR
    Posted 05-28-2018 09:03 AM
    Hi George,
    Your case might be a different issue, as Mangala wasn't talking about a TEST company in the initial post.
    To fix your TEST company refresh login issue, there are two options:
    - run a script after you refresh a TEST company (this is mandatory) according to KB871973. However this doesn't solve the user access which you have to fix manually in SQL server as the security will be inherited from the LIVE DB after the restore
    - user GPPT from Winthrop DC as it has a Database validation tool to check the proper synchro between the GP user access for a TEST company and the SQL server security. Way easier than doing it manually. However, you still have to run the script from KB871973 to fix the TEST company identity vs. the SY01500 table.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------



  • 13.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    Posted 05-29-2018 08:55 AM
    Hi Mangala,

    This may seem like a silly question, but are users always entering both username and password with case sensitivity? In instances where users always have the "Remember user and password" box checked off, once they have to actually enter their information they sometimes forget what they entered before they checked the box, and a username of testuser is different than TestUser when logging in,

    ------------------------------
    Scott Davis
    Trudell Medical Limited
    London ON
    ------------------------------



  • 14.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 06-01-2018 09:12 AM
    I would recommend utilizing GP Power Tools or maybe even a Dex SQL log to help identify what is happening.

    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power & Water
    Muscatine IA
    ------------------------------



  • 15.  RE: User login issues - This login failed. Attempt to log in again or contact your system administrator

    SILVER CONTRIBUTOR
    Posted 09-14-2018 12:06 PM

    Circling back to this discussion because I've just come across one reason for this error message.

    We had an individual getting this error while attempting to log into the web client. After days of investigation, I found the cause:
    The user in question had been married some time in the recent past. We had created a new GP user account for the user and inactivated the old one.
    However, the old one was still tied to the active AD directory account in GP.

    We use Fastpath to create our new GP users, and Fastpath ties the GP User ID to the directory account. So we unknowingly had 2 user ids tied to the same directory account. I removed the directory account from the inactive user id and had the user try again. Voila! Problem solved.

    User setup window

    We have added the step of removing the directory account from any inactive user to our process.


    Wanted to share this discovery, as I didn't see a solution listed here.



    ------------------------------
    Mark LeRette
    Application System Analyst II
    Muscatine Power & Water
    Muscatine IA
    ------------------------------