Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Resetting GP account l...
Microsoft Dynamics GP (Archived)

Resetting GP account locks out SQL Account

(0) ShareShare
ReportReport
Posted on by Arthur Crites 50
Our setup is GP10 with SQL2005 backend, and we have Password Policy Enabled. If I create a new account in Great Plains I am able to for the user to change the password. When they log in they can change their password without an issue.  The problem I have is when already existing users log into GP and try to change their passwords. Once the user changes the password and logs out of GP it instantly locks their user account on the SQL server. The only way I can unlock them is to remove Enforce Password Policy then re-add it to remove their locked status.  Has anyone found a fix for this?

 

*This post is locked for comments

  • Arthur Crites Profile Picture
    Arthur Crites 50 on at
    Re: Resetting GP account locks out SQL Account

    We tried with 3 and it's still locking up.

    There was also a link to a ticket in your blog but I was unble to get to it.

    I will try to get an MBS login so I can view it.

  • winthropdc Profile Picture
    winthropdc on at
    Re: Resetting GP account locks out SQL Account

    With v10.00 SP2 you should be able to set the system to 3 attempts.

    Is there still an issue?

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

  • Arthur Crites Profile Picture
    Arthur Crites 50 on at
    Re: Resetting GP account locks out SQL Account

    I was able to check our server, and we are running SP2 for Great Plains 10.

    I ran a test with our group policy and set it to 5 invalid attempts and the password changes on Great Plains work like a charm. Only issue is we have to have to set to 3 invalid attempts, which from what i understood SP2 was suppose to resolve. So accounts will still lock out.

    Would you have any other ideas before I give MS a call?

  • Arthur Crites Profile Picture
    Arthur Crites 50 on at
    Re: Resetting GP account locks out SQL Account

    David,

    thank you so much, I am going to go through this now. You just saved me from an Auditors Nightmare.

     

    Artie

  • winthropdc Profile Picture
    winthropdc on at
    Re: Resetting GP account locks out SQL Account

    Hi Arthur

    I would have a look at my blog posting as this describes how the password system and encryption works.

    http://blogs.msdn.com/developingfordynamicsgp/archive/2008/10/02/why-does-microsoft-dynamics-gp-encrypt-passwords.aspx

    If you are running a version of GP 10.0 earlier than SP2, you will need to ensure that you increase the number of password attempts by a multiple of 4.  See the posting for an explanation and link to the relevant KB.

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

     

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans