>>>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.


Start SSMS and connect to this Database engine.
Right click on Server name and choose Properties.
Select "Security" tab and switch to "SQL Server and Windows Authentication mode"
Then make sure that your sa login is not disabled or create new one that has the same privileges as [sa].