>>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.
First, thank you. I have been looking into different properties of the databases of this SQL Server instance. And it looks like they are all set for Windows Authentication. At least, I can't seem to see anywhere where it would say SQL Server authentication. And yet, I cannot connect to one of the databases from my VFP application. I will try to create a test database to see if this will work.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
