Locked User

(0) Share

Report

Posted on by Community Member Microsoft Employee

I’m having a problem with this error message (below). Is there a table I could clear up for this? I’ve clear the activity, sy00800 and delete tempdb.dex_lock and session tables. Usually it would allow me back in after 30 minutes, now it’s been 2 days.

Error Message: “Your User ID has been locked out of the accounting system…”

GP 9, Omini Tools

Thanks for any help.

Hung Tran

*This post is locked for comments

All responses (5)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Locked User

I figure it out, it was the Omni Tool security.

Thanks for your help.

Hung
Community Member Microsoft Employee on at

Like (0)

Report

RE: Locked User

I'm still gettting that message. Do you think this is a GP error message? I think it could be the Omni Tool. Have you ever come across this message before?

Thanks

Hung
Community Member Microsoft Employee on at

Like (0)

Report

RE: Locked User

Log in to GP as 'sa' and change the user's password - see if they can log in.

Look at Security in SQL for that user - right click and select properties - there is a tick box somewhere marking the user as disabled - untick it.

Ian.
Tristan Clores 2,812 on at

Like (0)

Report

RE: Locked User

Hi Hung,

Run the script below:

delete tempdb..DEX_SESSION

delete tempdb..DEX_LOCK

delete DYNAMICS..SY00800

delete DYNAMICS..SY00801

delete DYNAMICS..ACTIVITY
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: Locked User

Check the following reference for Victoria Yuidin,

victoriayudin.com/.../sql-view-for-user-activity-in-dynamics-gp

hope this helps