This error also happens when the user is spelled wrong or the password is incorrect. Microsoft does provide us with an confusing errormessage which does not always describe the actual problem I just spend half an hour being able to create a database connection without any problem using a full access account but having the 'incorrect sql native client' when using a read-only account (which turned out to be incorrectly spelled).
... View more