web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP password expiration
Microsoft Dynamics GP (Archived)

GP password expiration

(0) ShareShare
ReportReport
Posted on by Sharon Burley 1,970

can anyone explain why GP sometimes lets a user log in, and then after they start working, they get an error message because their password expired. we use Citrix and i'm not sure if that has something to do with it. anyone know? 

*This post is locked for comments

I have the same question (0)
  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: GP password expiration

    its not citrix, its the password expiration itself

    if you turn on password expiration and I change my password at 10:00 am then when the password finally expires it expires at 10:00am.  If you are logged in at the time, then you are still expired.  You lose your connection to sql (by now having an invalid password).  The sql messages you get are pretty cryptic.  

    Hope that you are not posting at the time.  Close GP and log in again so that you can be prompted to reset your password as you log in again.

    it would be so much better if it was programmed to know that the password would expire that day and had the user reset as they logged in for the day rather than in the middle of the day in middle of processing / posting.

    ian

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at
    RE: GP password expiration

    Thanks! That's a big help. Do you know if there is a way to see how much longer a user has before their password expires? Or how long it takes from the reset for it to expire?

  • Verified answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: GP password expiration

    Hi Sharon

    Reviewing

    microsoft.public.greatplains.free-usenet.eu/Password-Expires-in-the-middle-of-the-day_T22590211_S1

    it seems that the password expiration is tied to active directory settings.

    Have a look at this

    mbsguru.blogspot.ca/.../dynamics-gp-password-expiration-notice.html

    this person has an add on for GP that will warn you that your password is coming due.  It has some pretty big names from the GP community thanking its author so it lends legitimacy, but I am leary of a non commercial (enhancement fees = warranty) add on.  If I install it is definitely going on a test box first.

  • Sharon Burley Profile Picture
    Sharon Burley 1,970 on at
    RE: GP password expiration

    very helpful! thank you very much! i'm not sure that i will download the free tool but will definitely use the script from mariano.

  • Community Member Profile Picture
    Community Member on at
    RE: GP password expiration

    Its all down to a combination of your domain and GP settings.

    Firstly you have chosen to use the Advanced SQL options in the GP User Setup window.

    This uses the AD security settings. In your AD security settings you have set up that passwords expire at a certain interval. AD tracks this interval exactly - so if your expiry period is 30 days and you change the password at 10am today....in 30 days at 10am the password will expire.

    This is why in GP - you get password expiry notices while the user is logged in. They log in at 9 am and then at 10am they get the expiry message.

    There is a tool available that tracks the domain password policy, recognises when a password is due to expire, and warns the user when they log into GP first thing. So in the above example, when the user logs in at 9 am, they would get a message warning them their GP password will expire shortly and give them the opportunity to change it now....before they are in GP proper. However the user could ignore this...and they will get the expiry notice at 10 as normal. If they do change it on first log in at 9 am...then AD will start to track a new 30 days period...which expires at 9 am in 30 days time.

    I don't know of a 'solution' to this issue other than the above...or setting passwords to never expire in either

    GP or AD.

    Ian.

  • Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: GP password expiration

    hi Ian

    you tease us that there is a tool available.... but then don't tell us what it is.  Is it the one I linked to in my post?

    thanks!

    Ian

  • Community Member Profile Picture
    Community Member on at
    RE: GP password expiration

    Hi Ian,

    Yes sorry :). its the one linked in your post.

    I should learn to read earlier messages!!.

    Best regards,

    Ian.

  • Angel Nuñez Profile Picture
    Angel Nuñez on at
    RE: GP password expiration

    Has anyone tested this in GP 2013? or is there any other solution to this?

  • Suggested answer
    sueconrod Profile Picture
    sueconrod 337 on at
    RE: GP password expiration

    Just went into Connect because I don't see where this has been fixed in 2013 either.  Like any other Microsoft tools, it can't let us know 5 days a head that it is going to expire.  And Mario Gomez has to come up with a fix in VBA and yet Microsoft hasn't added if into the system yet.

    Here is where you can go vote to get this one fixed.  Hopefully they will listen to us, I've wasted too much time with my users on this issue and then having them logged out, they find out that their pw expired in the middle of them doing something and loosing a whole lot of work.

    connect.microsoft.com/.../gp-password-expiration

    BTW, connect is where you can go and make suggestions for product changes.  So, you can look up and see if there is something you don't like, that doesn't seem to work the right way etc.  and then get people to vote on it.  When they see it is an issue, they put it in the next version and if it is a hot enough issue, it can sometimes be put into the next Service pak

  • Cal Quigley Profile Picture
    Cal Quigley 50 on at
    RE: GP password expiration

    I have tried the DLL at this site mbsguru.blogspot.ca/.../dynamics-gp-password-expiration-notice.html.  For the PC's it worked on, it was great.  For some reason it does not work for all PC's.  I have checked the rights to the Dynamics GP folder and did not find the problem.  

    Users also have a habit of not logging out of GP for several days and I ran into the problem of the users never seeing the message.  

    So I wrote a stored procedure that will email the user once their password will expire in x days.  I used this sites SQL query as a starting point to write the stored procedure:  https://gallery.technet.microsoft.com/When-will-a-SQL-login-d6fbb6df.

    I put each user into the internet information table (sy01200) as an employee to store each users email address.

    If the user has not been setup in the sy01200 table an email is sent to me so I can setup the user.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans