Hi.
I have set up Sql express on a server, and attached a Database from my development machine, an am using Sql Server Express Mangagement studio to access it..all working fine.

I now need to give access to it from a VFP APP that will be accessing it over a LAN , and am unsure what connection string to use, or the best way to do this. I have initally set it up using Windows authentication... is this the usual type of security for SQL databses?

In SqlExpress mangemnt studio, the following are set up:
Server Name = MySRV/SQLEXPRESS
Using Windows Authentication

Any help appreciated
Regards,
Gerard