it sounds like the authenticate user behavior is set to use the ID column in your database as the username column.
In the wizard, It will default to the ID column for username, and password columns, you need to manually select the correct columns to use.