>Hi,
>
>When I access a named instance of SQL Server on my computer via SSMS I use Windows Authentication. I can get to any database and view tables, etc.
>
>Is it possible that, from an application (e.g. VFP 9 application), one of the databases can only be accessed using SQL Server Authentication?
If your SQL Server is set up for mixed mode authentication you can use either kind of authentication per database.
Your Server Administrator account will always have access to the databases, but that and the sa account are the only accounts that always have access. You can add any other account as users in any role to individual databases.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________