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

Check the server.

In SSMS, right click on the server in the Object Explorer pane and select properties.
In the Server Properties window, select Security.

You should see a Server authentication section in the right hand pane that tells you what authentication modes are allowed. This is a SQL server-wide setting. If it is only set for Windows authentication you will not be able to use SQL authentication on any database on that SQL server.