If I understand correctly - doesn't this mean you'd have to have a different connection string for each user? That our build it dynamically somehow of course. Does the ODBC connection work if you setup one in windows?

>Hi,
>
>I am installing a new application. The VFP 9 application works with the SQL Server.
>
>If I set up to use Integrated Security, the application connects to the SQL Server, no problem.
>
>Then I created a user and set up the user in the DB -> Security -> Users of the DB. I checked the option db_owner in the the Owned Schemas and Memberships. Should this be enough to have the application connect? Because it does not.
>
>What else should/could I do?
>
>TIA