Great Plains 2013, sql server 2012 - Account lockouts

(0) Share

Report

Posted on by Rick Heinrichs

Hi Everyone,

I noticed a few postings somewhat similar but does anyone have issues with the sql password policies? I am having an issue where if I turn on the enforce password policies where the account threshold in our organization is set to 8. verified this on the sql server in local security policy. However if I type my GP login wrong the sql server records the attempt as 4 tries. So you can see I don't actually get 8 tries I only end up getting 2. Anybody else have the issue? Suggestions without changing the maximum? Thanks

-Rick

*This post is locked for comments

All responses (4)

Answers (1)

Rick Heinrichs on at

Like (0)

Report

RE: Great Plains 2013, sql server 2012 - Account lockouts

we have not had any issues since being on GP 2013 R2 and SQL 2012 sp2
Community Member Microsoft Employee on at

Like (0)

Report

RE: Great Plains 2013, sql server 2012 - Account lockouts

Was this issue ever fixed? What build number?
Rick Heinrichs on at

Like (0)

Report

RE: Great Plains 2013, sql server 2012 - Account lockouts

Ok Thanks Jonathan
Verified answer

Jonathan Fear on at

Like (1)

Report

RE: Great Plains 2013, sql server 2012 - Account lockouts

This is a bug I actually found last week Rick. The issue is that one GP login attempt on GP 2013 equals 3 SQL passes. This should be fixed in SP2. I would recommend you guys increase the lockout threshold number in AD to 10. This way if a user enters the wrong password 3 times for GP it will lock the account when they try the 4th attempt.