Dynamics GP – Your login failed because of a database error. Contact your system administrator for assistance

Recently I encountered an issue when a user was attempting to login to Dynamics GP. After entering their user name and password they were receiving the error below which prevented access:

Your login failed because of a database error. Contact your system administrator for assistance.

On this occasion I found to fix the issue I had to remove the users login from the ACTIVITY and SY00800 tables in the DYNAMICS database using the SQL statements below:

DELETE FROM DYNAMICS..ACTIVITY WHERE USERID=’<UserID>’

DELETE FROM DYNAMICS..SY00800 WHERE USERID=’<UserID>’

Replace <UserID> with the User ID in question.

After running the scripts the user could then access Dynamics GP without issues.

I hope this helps anyone else who stumbles across this issue in the future.

Thanks for reading

One thought on “Dynamics GP – Your login failed because of a database error. Contact your system administrator for assistance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s