I have created a ADF using MS Application Def Designer and I have the connection string to the LOB using the DB username & password; the authentication mode is set to passThrough:

Data Source=DBName;Initial Catalog=DBtable;User ID=Username;Password=Password

When I load the ADF and put the LOB url in the browser and add a parameter I get a " The Business Data Catalog is configured incorrectly. Administrators, see the server log for more information." error.

I check the server event log and i see i have an error on there:

A Metadata Exception was constructed in App Domain '/LM/W3SVC/932451533/Root-2-129167343246621663'. The full exception text is: The LobSystemInstance Property 'AuthenticationMode' has a value that requires 'Integrated Security' in the connection string

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I have changed the FindAll MethodInstanceType in the ADF file to Finder. I have also tested the authentication modes as revert to self. I cannot use windows credentials because this DB has a specific account for reading only, and i cannot add a SharePoint user to it.