Microsoft Dynamics GP (Archived)

Dynamics GP user SA - Your ID has been locked out of the accounting system

(0) Share

Report

Posted on by alsantiago

100

sa at SQL level is fine, the account is not locked.

Environment GP2010.

Message: your User ID has been locked out of the accounting system. contact the system administrator.

Please note this is happening with user ID: sa

Troubleshooting steps:

1) I even tried: ALTER LOGIN sa WITH CHECK_POLICY = OFF; & ALTER LOGIN sa WITH PASSWORD = ’password’ UNLOCK ; Same problem persist when I logon into a company with SA.

*This post is locked for comments

All responses (24)

Answers (2)

Community Member on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Everyone shares the same client machine to log into our test environment. They remote desktop in.
Bill Campbell 12 on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Richard W wrote : "I tracked it down to different versions of the SQL Native client."

I too have seen this from one workstation to another - when the same user can access on one machine but not the other - it was weird. I resolved by doing a clean client installation - after uninstalling and tossing the SQL Client - and let the system default the name in ODBC - then all was well.

I believe it was a SQL NClient issue mismatch. Just my comment.

Bill
Community Member on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Yes, I have everyone as full access
Suggested answer

Bill Campbell 12 on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Larry on the TEST system does the user have access to create/modify files on the workstation? I have seen times when if the user does not have some permissions on the system it will fail the login.

Bill
Community Member on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

ok, no its only 6 characters no caps, nothing special.
Derek Albaugh on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

I apologize, I meant to say 'more than' 15 characters, as Dynamics GP only allows 15 characters for user passwords, and we've seen this cause user login issues when they have passwords that are longer than 15 characters, because obviously the passwords get cut off and are invalid.

Special characters can cause issues as well, as SQL doesn't always know how to read some special characters.

Thanks
Community Member on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Its only 6, but I will try and make it more than 15 and with special characters
Derek Albaugh on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

I just happened to think.......is this one user's password less than 15 characters and no special characters in it?

We've seen this cause issues with user logins as well......

Thanks
Community Member on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

Yes and we get the same results. Last time this happend i had to add a 1 or some other character to the user and it worked fine.
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Dynamics GP user SA - Your ID has been locked out of the accounting system

I have seen this before. Have you tried creating a new user ID for her in GP? Completely drop the old one and have her use the new one.